Joe,

I don't see this in VFP7SP1 here.

I wonder if you'd get a different resukt using a NOFILTER clause?

good luck


>Hello all! I have a SQL Select statement storing the results to a temp table. When the Select statement runs and doesn't return any results, _TALLY is returning 1. Has anyone seen this before? Can anyone tell me why this is happening? If I store the contents to a cursor _TALLY returns the correct value, but I have to use a table because of other processing that follows.
>
>TIA!