Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to implement a progress bar while running a remote v
Message
 
À
05/05/2021 17:10:39
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01680151
Message ID:
01680186
Vues:
41
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform