Set up your view with alias names Good LUck, Manuel Texmaster Express wrote: > Good afternoon. > > I finally did my first outer join view (thanks Dr. R>), and have noticed > some strange behaviour when running the same view off a report. I'm > wondering if I'm trying to make RBase do something it wasn't meant to do. > > My view runs fine at the R> prompt. When run through Reports, it builds up > the .$$$ sort file until I have to do a three finger salute and close down > RBase. However, if I recreate the view (which uses several functions, such > as MAX(t2.charge), etc) without naming the columns (Create View as (Maximum) > MAX(t2.charge), it runs just fine. Unfortunately, the calc'd fields won't > display in the report, only the group by column, so I do need to do it the > first way. > > Any idea why it crashes the sort file through Report but not in a Select via > the R> prompt? > > Thanks, > > Dan
begin:vcard n:de Aguiar;Manuel tel;fax:(323)661-7698 tel;work:(323)660-3511 x-mozilla-html:FALSE url:http://www.mdenterprises.net org:M|D Enterprises adr:;;2412 No. Commonwealth Avenue;Los Angeles;California;90027-1206;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Developer note;quoted-printable:The information contained in this e-mail may be privileged, confidential,=0D=0Aand protected from disclosure. If you are not the intended recipient, you=0D=0Aare hereby notified that any dissemination, distribution or duplication of=0D=0Athis communication is strictly prohibited. If you have received this=0D=0Acommunication in error, please notify the sender immediately and delete all=0D=0Acopies.=0D=0A=0D=0Ahttp://www.mdenterprises.net=0D=0Ahttp:/www.databasedeveloper.com=0D=0Ahttp://www.MdrBASE.com=0D=0A x-mozilla-cpt:;-1 end:vcard
