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:05:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
05/05/1998 13:02:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00097082
Message ID:
00097090
Views:
19
>>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform