[RBASE-L] - SV: Group By

[Gunnar Ekblad]

Jan

I always have the same trouble, I guees it is important that the group by
clause holds all the the selected column names..

But since I don’t see what you trying to achive I am at los!

 

Gunnar Ekblad

Kontema IT AB

Hästholmsvägen 32

S-131 30 NACKA

SWEDEN

+46 070 545 50 38

[EMAIL PROTECTED]

 

-----Ursprungligt meddelande-----
Från: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] För jan johansen
Skickat: den 26 juni 2008 19:46
Till: RBASE-L Mailing List
Ämne: [RBASE-L] - Group By

 

I always seem to not get his right.

What is wrong with this?

 

SET ERROR MESSAGE 677 OFF
DROP VIEW tCustInvoiceView
SET ERROR MESSAGE 677 ON
CREATE TEMPORARY VIEW `tCustInvoiceView` +
(CUSTNO,INVOICE#,DELDATE,NETSALE$,paid_YN) +
AS SELECT +
CUSTNO,INVOICE#,DELDATE,NETSALE$,paid_YN +
FROM DAYSALES +
GROUP BY CUSTNO, INVOICE#

 

gives an error message

-ERROR- Illegal column specification (2512)

If I leave off the group by it works fine.

 

Jan