>>>I'm using a query which uses the set filter to command. Good so far. But when the result of the set filter is no records, I need to be able to test for that, so I can take some action (message or otherwise). I see that RECC() doesn't respect the Set Filter to command. Can anyone tell me what does?
>>>
>>>Thanks!
>>>
>>>Sylvia
>>go top
>>if eof() && if .t. no records
>Sammie,
>You're right but "go top" with a filter is so slow. Use locate instead.
>cetin
You could be right about that. I ran some tests(100 reps of each) on a 400K record table. I haven't had time to really go thru the figures but it looks like on a random filter set on a EXCLU open the goto ran a little faster. With the same test on a SHARE open the locate ran faster(but both took about twice the time as the EXCLU open). I'll run the 'NO RECORDS' filter later - they take about 3 minutes to run 10 tests(about 12 times the random filter shared) and I want to do 100 tests on each type open. I'll let you know what I find out.