And if Sami's suggestion doesn't solve it try without the colname=n in the union - the column size is already specified so just the colname _should_ be enough.
Regards, Alastair. ----- Original Message ----- From: "marc" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 11:17 PM Subject: problem with union > > Hi all > > I hate to ask but..... > Can anyone tell me why this code causes RBase to crash and > kicks me out of RBW 6.5++ latest patch? > > browse t1.custnum=7 AS patnumber, t2.f_name=12 AS FIRST, t2.l_name=12 + > AS LAST,'Charges'=12 AS charges, SUM(t1.ch_price) AS amount + > FROM tran_daily t1,ptinfo t2 + > WHERE t1.custnum = t2.custnum AND t1.tr_type = 1 + > GROUP BY t1.custnum,t2.f_name,t2.l_name,t1.tr_type + > union all + > select t1.custnum=7 AS patnumber,t2.f_name=12 AS FIRST, t2.l_name=12 + > AS LAST,'Payment'=12 as payment, SUM(t1.ch_price) AS amount + > FROM tran_daily t1,ptinfo t2 + > WHERE t1.custnum = t2.custnum AND t1.tr_type = 2 + > GROUP BY t1.custnum,t2.f_name,t2.l_name,t1.ch_code > > Thanks > marc > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
