Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Bhavbhuti Nathwani
  Where is Bhavbhuti Nathwani?
 Rajkot
 India
 Bhavbhuti Nathwani
 Tags
Subject: RE: Invalid GROUP BY - at my wits end
Thread ID: 289125 Message ID: 289228 # Views: 22 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 29, 2010 5:25:35 PM         
   


> > Enginebehavior 70 will return random, midleading data when the agggregation value doesn't really correspond to the entire SELECT columns. That's why it is against the SQL rules.
> > Does that matter in your case? With 13 columns and two SUMs it looks to mee like a data sheet no human will scutinize to closely anyway.
>
> Hi Anders
>
> I am sorry I was not able to under what do you meant by the first statement. I still have a GROUP BY on the first 3 columns even in ENGINEBEHAVIOR 70.
>
> This is supposed to be accurate as it reflects accounting.
>
> Will EB 80 make things better?
>
> Please advise
>
> Thanks and regards
> Bhavbhuti

Yes the fist three will be right for the computation of the sum, but the relation of the rest of the 13 columns to the sum is nebulous.

-Anders

ENTIRE THREAD

Invalid GROUP BY - at my wits end Posted by Bhavbhuti Nathwani @ 12/28/2010 2:59:24 PM
RE: Invalid GROUP BY - at my wits end Posted by Bhavbhuti Nathwani @ 12/28/2010 3:09:19 PM
RE: Invalid GROUP BY - at my wits end Posted by tushar @ 12/28/2010 3:14:20 PM
RE: Invalid GROUP BY - at my wits end Posted by Bhavbhuti Nathwani @ 12/28/2010 3:21:25 PM
RE: Invalid GROUP BY - at my wits end Posted by tushar @ 12/28/2010 3:33:31 PM
RE: Invalid GROUP BY - at my wits end Posted by Bhavbhuti Nathwani @ 12/28/2010 5:18:06 PM
RE: Invalid GROUP BY - at my wits end Posted by Anders Altberg @ 12/28/2010 6:21:27 PM
RE: Invalid GROUP BY - at my wits end Posted by Bhavbhuti Nathwani @ 12/29/2010 6:15:51 AM
RE: Invalid GROUP BY - at my wits end Posted by Anders Altberg @ 12/29/2010 5:25:35 PM
RE: Invalid GROUP BY - at my wits end Posted by Bhavbhuti Nathwani @ 12/29/2010 5:30:20 PM
RE: Invalid GROUP BY - at my wits end Posted by Suresh Adhikari @ 12/28/2010 5:20:26 PM
RE: Invalid GROUP BY - at my wits end Posted by Bhavbhuti Nathwani @ 12/28/2010 5:31:21 PM