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
