OH Yes - That IS IT! Thanks Matt - its SO MUCH Appreciated! I had a similar problem about a year ago or more - and I posted it here. It was the same problem.
For this particular instance - I'm still working on this screen(which I posted about here on the list a little while ago) that must be used from within an older system (running under VFP7 - but looks like FP for DOS w/white text on blue screens) - and ALSO within the newer system for this client (that system is VFP9 and has True graphical type screens). I will temporarily switch that Compatibility mode to make it work! Thanks again, -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of M Jarvis Sent: Wednesday, July 18, 2012 1:50 PM To: [email protected] Subject: Re: SQL & Grouping Problem... On Wed, Jul 18, 2012 at 10:36 AM, Kurt Wendt <[email protected]> wrote: > I'm getting this error - it claims that GROUP BY is Missing or Invalid. > And, for the life of me - I don't see the problem. I've done Grouping > before to Sum a particular column - so, just not sure why its not > working this time around. > I can't remember the name of the setting, but check your SQL Compatibility mode to see of Group By is enforcing that you must make reference to all fields in the SELECT statement. -- Matt Jarvis Eugene, Oregon USA [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/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** 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.
