>>Eric,
>>
>>Why do you expect SET ENGINEBEHAVIOR 70 to fix problems in your code?
>>
>>>I tried to run a vfp7 application from vfp8. I got problems with most of my forms since I use intensively sql to get data. SO I put the SET ENGINEBEHAVIOR 70 command in my startup prg. It says in the documentation that it is a global setup. Is it really ? because I still have the problems...
>>>
>>>thks
>
>Because it was working in vfp7! In all the cases, these are SELECT-SQL commands that behave well under vfp7 and bad in vfp8
>For example: SELECT field1, field2 as myas from ... order by myas
>I don't care to be a good vfp8 citizen for the future development but I would like my existing apps to run without updating all the code...

You example should work with SET ENGINEBEHAVIOR 70. Can you post actual Sql Select and Error message you get?