>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
>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