Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Gun control
Message
From
19/11/2000 12:01:10
 
 
To
19/11/2000 11:19:17
General information
Forum:
Politics
Category:
Other
Title:
Miscellaneous
Thread ID:
00443455
Message ID:
00443461
Views:
24
Don't consider it with indexing (and for that matter don't use REINDEX). You have to jump through lots of hoops to make it work AND it will slow things down because the calculations have to be made, screen updated, write a larger key, etc.

You can't hook anything in to PACK. But, what you can do is COPY TO and show a progress bar using the FOR condition.


>I work with large tables clear up to the 2Gb limit, dialed in to client sites and running processes remotely, including bulk processes such as pack, reindex, copy etc. These take a long time on big files/slow networks and I need a visual progress indicator, not just for me to monitor the status, but to indicate to onsite staff that there is an active process currently running!!
>
>Obviously, progress bars that require manual updates would never work. So I tried using ZTHERM and setting the auto update expression to:
>
>('RECNO()/RECCOUNT()*100',1)
>
>But it doesn't seem to update while a bulk process is running. I know that VFP keeps track internally of where it is in these bulk processes because it updates the numbers shown in the status bar. But I can't find a SYS() or anything else that contains these displayed values where I can trap them. But more than that, I KNOW there is some kind of internal progress bar class that works within bulk processes because it will pop up when I MODI STRU on a big table, saying RECORDS ADDED, REINDEXING, PACKING MEMO FILE, etc. and showing a moving percent-complete bar. This is precisely what I want to implement.
>
>Any tips on accessing this internal class, or info on any 3rd party stuff that can do this, will be most appreciated!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform