Progress of an executing SELECT statement? 
Author Message
 Progress of an executing SELECT statement?

Hi,

I'm using the .Execute method to run a SELECT statement in my program.
The SELECT takes records from my Access database and puts them into
another datasource, eg. (takes data from source biblio.mdb and puts it
into an Excel spreadheet)

Dim MyDb As Database
Set MyDb = Workspaces(0).OpenDatabase("c:\temp\biblio.mdb")
MyDb.Execute "SELECT * INTO _
[Excel 5.0;DATABASE=C:\temp\].[test4.xls] FROM [authors]"

The user doesn't know this is happening, and I have no control over how
large the source data table will be, so this SELECT could take some
time.

I want to give the user some feedback to let them know how long the
process will take, eg. a progress bar - can I find out the progress of
my SELECT, while it is running?

Many thanks in advance,
Andy Bibby.
----
Programmer, ADG Computer Systems Ltd, Oxford, UK.



Tue, 03 Jul 2001 03:00:00 GMT  
 Progress of an executing SELECT statement?
No. You would have to do this via an asynchronous query, and DAO supports those
only in ODBCDirect workspaces.

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please post/reply to the newsgroup(s) so
that everyone can benefit from the discussion.

Regards,

Klaus H. Probst, MCP


       ICQ: 22454937
      The VB Box: http://members.xoom.com/kprobst/
~~~~~~~~~~~~~~~~~~~~~~~~~~~


Quote:
> Hi,

> I'm using the .Execute method to run a SELECT statement in my program.
> The SELECT takes records from my Access database and puts them into
> another datasource, eg. (takes data from source biblio.mdb and puts it
> into an Excel spreadheet)

> Dim MyDb As Database
> Set MyDb = Workspaces(0).OpenDatabase("c:\temp\biblio.mdb")
> MyDb.Execute "SELECT * INTO _
> [Excel 5.0;DATABASE=C:\temp\].[test4.xls] FROM [authors]"

> The user doesn't know this is happening, and I have no control over how
> large the source data table will be, so this SELECT could take some
> time.

> I want to give the user some feedback to let them know how long the
> process will take, eg. a progress bar - can I find out the progress of
> my SELECT, while it is running?

> Many thanks in advance,
> Andy Bibby.
> ----
> Programmer, ADG Computer Systems Ltd, Oxford, UK.



Tue, 03 Jul 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Progress of EXECUTEing a SELECT statement?

2. Select * vs Execute Statement

3. executing SELECT statement with return value from other stored procedure

4. Cannot execute select statement

5. Very simple - How to execute sub statements before the end statement

6. How to select the current record only with SELECT statement

7. getting progress % from an sql execute?

8. getting progress % from an sql execute?

9. Moving a progress bar while executing a continous action

10. Showing progress when issuing sql statement

11. Interrupting a VB4 statement in progress

12. SQL Statement and Progress???

 

 
Powered by phpBB® Forum Software