>>>I have noticed that when I run a SQL Select that is based on SUM() and COUNT() functions (to group certain records), the _TALLY returns a value greater than 0, even if no records match the WHERE clause. Is this by design? Or am I missing something?
>>
>>If you Select into a cursor, VFP will create a cursor with one record to hold the result, and _tally reports 1 which is the same as the number of records in this cursor.
>
>Therefore, I see that _tally in unreliable method of checking if SQL select found any "valid" records. What do you suggest to use then?
>
The COUNT() will return 0 if there's no GROUP BY and _TALLY will be 0 if there's GROUP BY and no records match WHERE clause..
--sb--