Can some one confirm this for me?
In VFP if you perform a SQL select and no records are found, then _tally is zero.
However, with MySQL and MsSQL, if no records are found, there seems to be one empty record in the cursor and _tally is one.
Is this true?
Instead of testing after a select with
if _tally=0
I've been using
if empty(table.PrimaryKey)
It seems to work, but I'm just a bit nervous.