>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...