Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to tell when Set Filter returns no records
Message
From
05/05/1998 13:08:33
 
 
To
05/05/1998 13:05:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00097082
Message ID:
00097094
Views:
24
>>>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
>>
>>If i have understood your question, you can issue:
>>
>>go top in (aliasname)
>>if eof(aliasname)
>> your actions...
>>endif
>carlos,
>yes this works but "go top" with a filter could make users think "system crashed" if a lot of recs and complex expression. Use locate instead.
>Cetin

ok.
Saludos,
A.G.P.
---------
Previous
Reply
Map
View

Click here to load this message in the networking platform