>>I'm actually in the process of doing the same thing (only going from VFP6). I've done this several times in the past as well.
>>
>>From what I've gathered there are several ways to go about it. In my case the application is only going to be around for another year or so and it's HUGE....so all I'm really doing is this:
>>
>>SET ENGINEBEHAVIOR 70
>>SET TABLEVALIDATE TO 0
>>SET REPORTBEHAVIOR 80
>>
>>...which for all practical purposes finishes the job (that and make sure anywhere you use the LOCAL statement you have comma's between the vars...
>>
>>So if you have something like this:
>>LOCAL lcVar1 lcVar2 lcVar3
>>
>>Change it too:
>>LOCAL lcVar1, lcVar2, lcVar3
>>
>>If you do the above then in theory the app should compile and you'll be just fine. If you don't want to use the SET commands and make it more VFP9ish, then one of the things you have to keep in mind is how the GROUP BY clause has changed......
>>
>>
>>
>>
>>>We are upgrading our legacy financial app from vfp7 to vfp9. Are there any papers out there pointing out gotcha's and pitfalls?
>>>
>>>Thanks..
>
>
>Thanks for the reply. We always use commas to separate variable definitions as per our standards. But the Group By could be huge.

Exact same situation here....which is why I decided to go with the SET ENGINEBEHAVIOR 70