>>I have been using _tally= 0 condition in my programs in VFP6 to check if any records are returned by SQL Select.
>>
>>In VFP9 a null record is returned and value of _tally is 1.
>>
>>How best should I change my code to verify if any useful records/rows were returned?
>It only happens "when using aggregate functions, such as MAX( ), in the SQL SELECT command without a GROUP BY clause, and no matching records are found, Visual FoxPro returns a result set with a single record and _TALLY set to 1. In versions prior to Visual FoxPro 9.0, no records are returned, and _TALLY is set to 0". You can use ISNULL() function to check return value.
Actually mine is a gigantic project with hundreds of places where i will need to change the _tally handling.
Thanks. That will save me half the effort!
Aman
-------
Lets fly away to the Land where there is Love & Peace