Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Progress Bar and Using SQL Passthrough to pull down data
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00351111
Message ID:
00351400
Views:
16
>>I am pulling down several large tables from an Oracle database and was wondering if anyone has come up with a means of showing the progress for this sort of operation. I have tried the "timer" route but it looks as if the timer events get put into the queue as the "SELECT" query eats up the cpu time. Any ideas?
>
>You might set the max for your progress bar to the number of passthrough cursors you are generating, bumping it ONE after each cursor is completed.

Hmmm, hadn't thought of it that way. I was hoping to mark the progress of the records themselves being downloaded. But worst comes to worst I could mark progress by the pathrough itself. Good idea.

I decided to try creating a remote view and then use the Fetchasneeded property to pull records bit by bit and update the progress bar. Not sure if this is a great idea but will give it a try.

Thanks again!

George
Everything we see or seems
Is but a dream within a dream
- Edgar Allen Poe
Previous
Reply
Map
View

Click here to load this message in the networking platform