Marc Catching up on old messages.
1. Test the two selects separately. Do they work consistently? If not, then you can narrow down which SELECT is the problem. 2. If they work separately, then the problem comes when you UNION them. Let us know what you find. David Blocker ----- Original Message ----- From: "marc schluter" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 3:16 PM Subject: [RBASE-L] - Re: RBW 6.5++ crase > 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 > >
