Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to implement a progress bar while running a remote v
Message
From
08/05/2021 10:00:41
 
 
To
06/05/2021 11:33:44
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01680151
Message ID:
01680235
Views:
51
Likes (1)
>>>Hello, this is one of the programming tricks that I have wanted to do for a long time, but have not had a need to make it happen until now.
>>>
>>>And this time I have developed a form that shows a few hundred invoices whose correct status, the user has to verify and take the necessary actions.
>>>
>>>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
>>
>>What backend are you using? Generally speaking I don't think it's possible to show a progress bar as the SQL is ran on the backend database -- however you could create a form that appears when you execute the query -- have it play a video or gif or something in a modal form.
>
>Hi Victor. I am using SQL Server. I did what you explained in your mesage previously. I used a tiny form with an animated gif in it. I show this form (modeless, not modal, because modal stops execution of the program). What happened is that just when the remote view begins to run, the animated gif remains frozen. Then, when the remote view finishes running the form I programmatically close it. Which does not works as I expected.

Did you use SQLSETPROP() to change the connection property to asynchronous mode?
(please note that when connection is in asynchronous mode necessitates some changes in your code -- statements that would normally block -- i.e. execution of code will halt until results are complete, will now "fall through" so you'll need to use a loop to check status to check for completion).
Previous
Reply
Map
View

Click here to load this message in the networking platform