Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to find orphans - seek vs SQL
Message
 
 
To
23/11/2000 03:09:29
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00444141
Message ID:
00445096
Views:
17
>Hi Nadya,
>
>>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.
>
>How aboutsomething like this:
>SELECT Table1
>nRecords=RECCOUNT()
>nResolution = nRecords / 100 && 100 steps in progessbar
>SCAN
>    IF !KEYMATCH(cYourValue, nYourTag, "Table2)
>        DO yourstuff
>    ENDIF
>    IF RECNO() % nResolution = 0
>       ..DO ShowyourProgessbar WITH RECNO()/RECCOUNT
>    ENDIF
>ENDSCAN
>
>Walter,
Walter,

The idea was to avoid scan the whole table :) The scan of table containing 4mln. records may take a long time :) I better give up the idea of timer.

You're right about deleted problem, I didn't realize, that deleted() won't help me here. This method in my case would be a little inaccurate from purilist point, but I think, it still can be used, because number of deleted records is low.
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