>>>>>I've taken over a VFP6 app I'd like to convert to VFP9.
>>>>>
>>>>>In the past all I've done is just add this line of code:
>>>>>SET ENGINEBEHAVIOR 70
>>>>>
>>>>>...then recompile the whole app and it worked. Of course that was done on VFP6 apps that I made, not ones that someone else had put together. Any other things I should take into consideration here??
>>>>>
>>>>>Thanks!
>>>>
>>>>I see you have already gotten a lot of good info from Sergey. (What a surprise!) If it were me I would crank up Code References and see how many GROUP BY clauses there are in the application. If it isn't a huge number it might be worth taking the time to fix them rather than ignoring non-compliant SQL code via SET ENGINEBEHAVIOR.
>>>>
>>>>So do you think you're going to be able to focus on your work over there? <g>
>>>
>>>So far the biggest problem I have is that at one point they lost the source code for this thing and had to ReFox it. Blah blah blah they lost 100% of the comments inside the code. From what I've gathered that happened "a year or so ago" so perhaps I will actually find a comment in here somewhere at some point but so far I haven't seen any at all. I've asked if they have an old backup of the source prior to that happening - figure if push came to shove it would be nice to at least have it for reference. Apparently they screwed up the version control gizmo they were using so bad that they couldn't tell what they had in production anymore, so they opted to refox the live .exe.
>>
>>Yeah, I have had clients like that. But they weren't in Hawaii <g>.
>
>Arggg...I stumbled across something else - someone here sure liked to use the "SET FILTER" command. 72 spots in the code where I see that. I surely want to get rid of those.....

Hmmm. It has never been my favorite technique but I don't think filters are as bad as their reputation (outside of grids). It is an optimizable command.