General information
Category:
Coding, syntax & commands
>>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only