Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp50 - Not Found()/Select
Message
From
24/02/1997 11:17:58
 
 
To
24/02/1997 11:07:31
General information
Forum:
Visual FoxPro
Category:
User groups
Miscellaneous
Thread ID:
00021798
Message ID:
00021801
Views:
30
>If you do a Select/From/Where and the where is not found, what is the return code? How can I tell if my
>where was not found. I use to do a "if !seek()".
>
>Rob

basically, Select-SQL returns set of records. After this command you can check _TALLY variable which shows how many records selected or 0.
Seek/Found returns logical variable: .T. if found and .F. if not. It's more logical to use Seek for search purposes (surely you have to have appropriate index tag).
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform