Hi all IDQUOTES are set to ` I changed the code to this below. It ran fine 2 times on trace, then ran the command file...crash. Restarted RBW trace worked once, trace crashed the 2nd time.
thanks marc BROWSE + t1.custnum=7 , t2.f_name=12 , t2.l_name=12 ,+ 'Charges'=8 , SUM(t1.ch_price)=9 + 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 select + t1.custnum=7 ,t2.f_name=12 , t2.l_name=12 ,+ 'payments'=8 , SUM(t1.ch_price)=9 + 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.tr_type --- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote: > > Marc, > > Follow Randy's suggestion (below) on using 'AS xxxx' > and > also make sure to SET IDQUOTES = ` (reversed single > quote). > > To check IDQUOTE SETtings: > > 01. Start R:BASE 6.5++ > 02. CONNECT dbname > SHOW CHAR > > Look at the last settings, IDQUOTES > > If blank or null, then: > > SET IDQUOTES=` > > Note: IDQUOTES are database specific settings. > > Have Fun! > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
