Fred

I did set the ENGINEBEHAVIOR TO 80 and that fixed the problem. However I wasted several hours and never saw anything in the help about a problem like this.

In fact in the VFP9 help for _tally there is an example of using _tally to count the number of customers in the following SQL statement.

*** copied from help
SELECT * FROM customer ;
   WHERE country = 'USA' ;
   INTO CURSOR temp
? _TALLY

So basically are you saying that in VFP9 forget using the _tally in your code as it will not return the expected results unless you set the enginebehavior to 80?

Thanks greatly for pointing this out. Are there any more gotcha that I need to know as I am converting over a very large project to VFP9. or could you point me to something that will define the things you need to tweak to get a VFP8 application to run in VFP9?

I hope I didn't sound harsh, as I truly appreciate your response. But it would sure be nice to know what other problems I will incur as I test my newly converted VFP9 project.

Gaylen



>>In VFP9
>>The variable lnarTotalc evaluates out to .null. as the _tally value is 1
>>
>>In VFP8
>>The variable lnarTotalc evaluates out to 0 as the _tally value is 0
>
>This is noted as a difference in the SQL between the versions of VFP. You could SET ENGINEBEHAVIOR 80 to work around it. VFP9 is more in line with the result set you'd get from SQL Server.