Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Progress bar for a query
Message
From
17/04/2002 09:46:27
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00645831
Message ID:
00645865
Views:
21
This message has been marked as the solution to the initial question of the thread.
Although not a great solution, we use SET TALK ON.

The following is another solution, though it may slow the query down somewhat.

Create a program, for example Test.prg:
pn_Count = pn_Count + 1
IF MOD( pn_Count, 10 ) = 0 && This is .T. every 10 records.
   * Update progress bar here.
   ? pn_Count
ENDIF

RETURN .T.
Code your select as follows:
PRIVATE pn_Count
pn_Count = 0
SELECT * FROM MyTable WHERE Test() AND (...other conditions...)
>Hello!
>I wish to give al better look to my forms when I run a large query using ADO.
>Now I show a 'wait window nowait after' the sql code and another at the end.
>How can I grab the status of the query and use it to assign the progress bar value?
>Thanks...
>Pedro
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform