Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting the process records in a sql-select statement
Message
From
04/02/1999 23:26:01
 
 
To
04/02/1999 17:56:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00184105
Message ID:
00184204
Views:
19
>how can i get the actual processed records in a sql-select statement to populate a progress bar. The sql use 3 tables.

The only to update a progress bar during a query (I don't recommend it for performance reasons) is to call a function inside the SQL statement:

SELECT Field1, Field2, MyFunction() as Dummy

and then MyFunction would do the updating. But getting a record count is impossible, because that is not the way SQL works.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform