Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you know if a SQL select didn't select anything?
Message
From
06/07/1999 23:54:02
 
 
To
03/07/1999 05:53:43
Rajatkanti Bagadthey
Skynet Systems P Ltd
Kolkata, India
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00236234
Message ID:
00238105
Views:
13
>select ....... from ....
>if _tally > 0
> * records were selected
>else
> * no records were selected
>endif

Thanx for your input. If you look back at the beginning of the thread, however, you'll see that I started off discouraging the use of _Tally, as some earlier experience had been unreliable. Jim Booth says thats not so, so your method would be just fine.

Thanx again.

Rob
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform