Hi Tore,

I've never heard of this before and have been relying on this for many years now. I have just done some testing and _TALLY appears to always return 0 if no records were selected, even if selecting into a cursor.

Can you give me a scenario where _tally will get set to 1 when no records are selected?


>>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.