Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I show progress for a stored procedure call?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00671017
Message ID:
00671254
Views:
14
Steve,

It isn't pretty.. You can use an asynchronous connection, and use SQLMoreResults() and a timer to periodically fetch the data, during the fetch you can at least tell them how much data has come back, but doing a % complete is going to be hard unless you make a pre call to find out how many records are going to come back.

>I am making a call to a stored procedure in a relational database(NOT VFP) using SQLEXEC. The stored procedure can take anywhere from a few seconds to a few minutes. I would like to give some indication that something is going on so the user does not think their system is locked up. Is there anything I can do?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform