Matthew - I'm going to look into this suggestion of your's right now - as I didn't know about this Behavior thing. I'm sure it IS related to my problem.
-K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jarvis, Matthew Sent: Friday, May 07, 2010 4:56 PM > -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Kurt Wendt > Sent: Friday, May 07, 2010 1:43 PM > To: [email protected] > Subject: Query Fails Under VFP9... > > ...and, yet - the SAME Query would work FINE under VFP7. And, it's > driving me NUTS that I can't figure out WHY! > > This is the Select Statement: > SELECT invoice, store, style, color, PPitem, ; > LineGroups, Sum(ShpTot) AS ShpTot ; > From &CurrTmpFile. ; > Where !EMPTY(AstFlag) ; > Group By Store, PPitem ; > Into Cursor InvLn_Sums > > The Error message I get is the following: > SQL: GROUP BY clause is missing or invalid. > > I find it VERY Strange that a Command that works under VFP7 does NOT run > when run under VFP9. And, I even just tested it again now - and sure > enough it functions under VFP7. What is your SET ENGINEBEHAVIOR set to in both versions? Check out: http://msdn.microsoft.com/en-us/library/ax9aye37%28VS.80%29.aspx Especially bits about GROUP BY. Thanks, Matthew Jarvis || Business Systems Analyst _______________________________________________ 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/289ea162f5642645b5cf64d624c66a14071a1...@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.
