>I am going to have to upgrade a project I look after from 7 to 9 - are there any things to look out for out of the starting gate, or ought it just be a recompile, and all is good? Many thanks for your input!
In moving from VFP6 to VFP9, some things that did cause a few headaches (because of some poor coding technique):
* Some changes in default settings -- such as SET EXCLUSIVE. It was ON in VFP6 and is OFF in VFP9 and could cause you grief if weren't careful to always specify SHARED or EXCLUSIVE on each of your USE statements.
* VFP9 is more strict on handling of SQL statements than VFP6 (e.g. the handling of GROUP BY) -- so recompiling and running in VFP9 will likely reveal some of the badly-formed SQL SELECT statements.

If I'm not mistaken, the p-code files (e.g. the FXP, APP) from older versions of VFP (at least as far back as VFP6 -- don't have earlier versions of VFP older than that to be able to confirm this) will run in VFP9 (though some difference in runtime environment will probably reveal some coding problems in the existing code that weren't apparent in earlier versions of VFP). The p-code files from earlier versions such as FoxPro for DOS and Windows won't work however (the engine is completely different).