On Sat, Jan 4, 2014 at 8:22 AM, jerry foote jer...@footegroup.com wrote:
Thank you Rafael that was what I what I was looking for.
---
Setting behavior to fix the problem is not going to work outside of VFP
data. Instead just follow the simple rule that everything in your select
and I think that in some very rare cases, complex SQL queries results with VFP9
differ from the same queries in VFP6 even if enginebehavior is set to 70. But I
have no example to show.
The Foxil
___
Post Messages to: ProFox@leafe.com
Subscription
Russell
Sent: Friday, January 03, 2014 9:25 PM
To: ProFox Email List
Subject: Re: Invalid Group By
Group by MANI_ID,MANIFEST_N,BILL_OF_LA,transfers,transfr_no,to_acct is what
you need.
On Fri, Jan 3, 2014 at 9:05 PM, Darren fox...@ozemail.com.au wrote:
Try
SELECT ;
MANI_ID
Thank you Rafael that was what I what I was looking for.
Jerry
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin
Sent: Saturday, January 04, 2014 8:01 AM
To: profox@leafe.com
Subject: Re: Invalid Group By
I would add that you need to put
LOOK_ACCT=127
select
MANI_ID,MANIFEST_N,BILL_OF_LA,transfers,transfr_no,to_acct,SUM(TOTAL_UNIT)
AS TOTAL_UNIT, ;
SUM(RELEASED) AS RELEASED,000 as releacnt , AS SUMTRANS, 00
AS SUB_BALANCE ,00 AS BALACEIS;
FROM transfers where to_acct=LOOK_ACCT .AND. TRANSFERS0 AND
: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of jerry
foote
Sent: Saturday, 4 January 2014 12:50 PM
To: profoxt...@leafe.com
Subject: Invalid Group By
LOOK_ACCT=127
select
MANI_ID,MANIFEST_N,BILL_OF_LA,transfers,transfr_no,to_acct,SUM(TOTAL_UNIT)
AS TOTAL_UNIT, ;
SUM(RELEASED
To: profoxt...@leafe.com
Subject: Invalid Group By
LOOK_ACCT=127
select
MANI_ID,MANIFEST_N,BILL_OF_LA,transfers,transfr_no,to_acct,SUM(TOTAL_UNIT)
AS TOTAL_UNIT, ;
SUM(RELEASED) AS RELEASED,000 as releacnt , AS SUMTRANS, 00
AS SUB_BALANCE ,00 AS BALACEIS;
FROM transfers
Thank Guys
Jerry
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell
Sent: Friday, January 03, 2014 9:25 PM
To: ProFox Email List
Subject: Re: Invalid Group By
Group by MANI_ID,MANIFEST_N,BILL_OF_LA,transfers,transfr_no,to_acct is what
you need
8 matches
Mail list logo