>>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).
Ed...
I forgot about _TALLY. I was not sure if it was a god idea to mix Embedded SQL with Fox syntax like "seek", "found()", etc…
I would think that all calls to the engine would be one or the other.
Rob