Hi David Both selects work separately.
Randy suggested I create a view or temp tab. I think that will solve the problem. Thanks for the help marc --- "David M. Blocker" <[EMAIL PROTECTED]> wrote: > 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 > > > > > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
