Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to find orphans - seek vs SQL
Message
 
 
To
22/11/2000 17:07:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00444141
Message ID:
00444787
Views:
12
>>Hi Walter,
>>
>>First of all, I would like to thank you again for this solution. I added a new FAQ entry about it, it would appear soon.
>>
>>Secondly, do you know, is there a way to display a thermometer here?
>>If I use scan...endscan for the whole file, I can show a progress bar easily. Since here I use a scan for !keymatch(...), this technique would not work. Do you have ideas? If not, it's not critical, wait window would be enough, I think.
>>
>
>You would have to get a COUNT FOR !KEYMATCH(... first to have an upper end for the progress bar.
>
>Is an index in use? If not, you could still use a progbar, just get the percent using recno()/reccount()*100 - if you get to eof() and the progress bar isn't done, force it to 100. It will jump periodically instead of having a smooth incrementation, but people are used to seeing M$ progress bars do that <g>

Hi Trey,

Could you please elaborate more? Suppose, you have 0 orphans. Scan for !keymatch() still took some time, because it's like setting a filter on a table. lnCount inside scan would be 0. Could you show in code, how can I display a progress bar in this situation? It's not critical, as I said, I just like to show something, to demonstrate, that system is working. Perhaps, Tom Cahagan (?) with his avi progress bar could help here. Tom, do you have an idea for this?

Thanks.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform