Be careful with Set Enginebehavior! This command is NOT an easy way to convert your program, but it makes it easier to fix one select statement at a time. They discovered that VFP7 amd VFP8 could give wrong result in some cases, and changed the SQL engine to fix this. And at the same time they also changed the SQL syntax to comply with SQL ANSI satndards,

This important change means that you must change all the select statements which reports error with enginebehavior 90. If you don't, you risk wrong results from your select statements!!!

>Hi
>
>At last I am porting my application to VFP9. is there a document with tips,tricks, or gotchas before deploying the application.
>
>So far, it looks painless as long as the EngineBehavior set right.
>
>thanks