Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to find orphans - seek vs SQL
Message
From
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:
00444900
Views:
30
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,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform