Hi Randy I removed the =xx. Trace worked 3 times, ran the code crash.
Thanks for your help marc --- randyp <[EMAIL PROTECTED]> wrote: > Dear Marc, > > Remove the =xx from the fields after your > UNION SELECT. > Field sizes are defined the first time. > > Keep trying, you are close. > > Randy Peterson > > marc schluter wrote: > > > 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 > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
