Re: Invalid Group By

2014-01-09 Thread Stephen Russell
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

Re: Invalid Group By

2014-01-09 Thread Jean MAURICE
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

Re: Invalid Group By

2014-01-04 Thread Rafael Copquin
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

RE: Invalid Group By

2014-01-04 Thread jerry foote
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

Invalid Group By

2014-01-03 Thread jerry foote
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

RE: Invalid Group By

2014-01-03 Thread Darren
: 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

Re: Invalid Group By

2014-01-03 Thread Stephen Russell
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

RE: Invalid Group By

2014-01-03 Thread jerry foote
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