>First if the app would have problems under 8.0 with things like SQL-SELECTS and unwell formed Group Bys ect. then you will have problems in 9.0 beta.
You can always use this:
SET ENGINE BEHAVIOR 70
....although I've seen another issue even after doing this.
If I do this...(myviewname is a remote view)
Select * from myviewname where myviewname.picked = .T. into cursor mycursor
...In VFP8 and VFP9 I have to do a tableupdate on myviewname in order to get all of the records I want. (where myviewname.picked = .T.) - in VFP7 this doesn't appear to be necessary - I get them without doing the tableupdate first. I haven't spent any real time investigating this yet - but it's one of those little things that could really mess things up (at least for some of my apps) when moving from 7 to 8 or 9.
>Also this is a beta so there may well be problems, but then you can give feedback to MS so that they can fix these 'issues' before the real release.
>
>My guess is 99.9%+ of the code in the app will work fine, it is that 1 in 1,000 lOC that may get-ya. <s>
>
>Anthony
ICQ 10556 (ya), 254117