>>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.
>
>I'm guessing there's a way to show an animated GIF, though that itself doesn't prove that the back-end is still executing the query.
>
>If it's taking 4-5 seconds, and if uses are growing impatient, is there an chance of refactoring the code (or data access approach), adding indexes, etc? I don't know specifics of your situation, so maybe you've already done that, but figured I'd bring it up.
I've had the problem when hitting a giant Oracle backend that had a kazillion records. I created a modal form that played a video, ran it before the requery started and closed it after the requery completed. In my case it was pretty simple to do because I had a classlib I wrote that did all the requerys, updates, etc. so only had to add it in my code in one place.
ICQ 10556 (ya), 254117