>Robert,
>
>>I downloaded the latest beta of version 9.0 and I was wondering how difficult it will be to move from 7.0? Can anyone name a few of the top issues I will have to deal with? I have several applications written in 7.0 and I am wondering how many gotchas I will run into.
>
>There are some SQL engine changes in both 8.0 and 9.0 that MAY break some of your existing code, mostly put in place to make VFP's SQL conform to accepted standards. For example, the GROUP BY clause must match up more closely to the SELECT clause.
>
>You can read about these changes in the help files and release notes (separate download), but to keep your app running as is without changes, you can issue

SET ENGINEBEHAVIOR 70

>However, note that doing this will turn off many of the new SQL features that you get with ENGINEBEHAVIOR 90 (the default).
>
>Also note that by default, the Public Beta turns OFF the new Report engine and puts the Report system into REPORTBEHAVIOR 80 mode so none of your existing reports will break. If you want new Report engine behavior, you can

SET REPORTBEHAVIOR 90

for individual reports or for your entire application.
>
>In that case, you might have to adjust the spacing of tightly-packed expressions on the report, since the new engine renders a little different in some cases. The team is working on improving that by release, but you should be aware of it in testing and realize that later revisions might reduce the number of adjustments needed.
>
>Also, I highly recommend that you get the Hentzenwerke book "What's New in VFP8" and also "New in Nine," which is being issued chapter at a time online right now. http://www.hentzenwerke.com

Thanks for all the useful information everyone. I appreciate it.