SQL statements with a group by clause will crash if you do not include all non agregate fields in the group by clause, which you never had to do in previous versions of VFP. This is so to make it compatible with most (not all) of sql server syntax
set enginebehavior 70 set reportbehavior 80 that should do the trick. VFP9 will run vfp6 code with no need to change anything, except perhaps for the menus. You should re compile the menus with VFP9. They will run in VFP9 but not in VFP 6, because I think it was in version 7 they changed the menu somehow. Keep a back up copy of the VFP6 compiled menus and you will be OK to use the VFP6 version again, just in case. Rafael Copquin El 10/08/2012 08:19 p.m., Gary Jeurink escribió: > Recently installed vfoxpro-9 and I still have 6.0 and all of it's working > projects. If I start up version 6.0, the applications all work but in 9.0 > they all crash. Where do I start to get each to run in ver. 9 or do I have > to build each from scratch. I upgraded because 6.0 was freezing up > occasionally in Win7 64 bit. > > > > Gary Jeurink > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
