Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to implement a progress bar while running a remote v
Message
 
To
05/05/2021 17:10:39
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01680151
Message ID:
01680186
Views:
40
>>>Well, to get to the point, these invoices are obtained through a remote view, this takes on average, about 4 or 5 seconds to execute, meanwhile the user thinks that his PC has frozen and begins to get impatient.
>>>
>>>Is there a way to display a progress bar (or at least an animated gif) while the remote view (or in some cases) stored procedure is running?
>>>
>>>TIA
>>
>>OK, I'm guessing the back-end database is something like SQL Server or Oracle. If that's the case, I'm not aware of any way to show a visual based on the progress of the query.
>
>Well there is a way in SQL server, at least if you have the proper rights:
>
>
SELECT 
>percent_complete
>FROM sys.dm_exec_requests
>WHERE session_id=51
>
>The session ID is the session on which it is running the query. You'll need to run the query asynchronously and use another connection to run the query above to get the status of the query.
>
>Its quite a bit of work and I agree that this might not be the right approach.

This has jogged my memory --- I saw this many years ago & yes technically yes it did work. Using gofish find & replace it might not be all that much work to get it to fly.
ICQ 10556 (ya), 254117
Previous
Reply
Map
View

Click here to load this message in the networking platform