>I'm using the _tally system variable to decide whether or not to print a report after runing a SELECT SQL.
>
>Sometimes the _tally variable has a value of 6545264 when there are actually 0 records returned.
>
>I have coded around this problem...
>
>i.e.
>
>if _tally > 0 and _tally != 6545264 then
> repo ... ...
>
>I was just wondering if anyone else has run into this problem before...
>
>Thanks for any enlightenment
Yes, since MS introduced filter/nofilter cursor the trustworthy of _TALLY is somewhat diminished (btw I would test it with NOFILTER, if you SELECT inot cursor). I didn't meet particular problem you mention, but if I would then I should better use RECCOUNT()<>0 to have safer code.
Edward Pikman
Independent Consultant