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/
