Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to tell if a query returns no rows
Message
From
12/06/2002 10:22:26
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
12/06/2002 10:07:42
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00667351
Message ID:
00667362
Views:
31
>Hello Group,
>
>I am querying a SQL Server 6.5 table to see if any of the school disticts are of some value
>
>i.e. SELECT * FROM studemo WHERE schdist = 29009.
>
>How would I tell if there were no rows returned?
>
>Thanks
>Jim

In Visual FoxPro, usually I would use the _tally variable, that returns the number of records processed. I am not sure whether this works in C/S.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform