At 03:39 PM 9/24/2001 -0500, Dan W. wrote:
>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?
Dan,
First, I would avoid naming the VIEW as Maximum. Secondly, I would
name all columns AS ALIAS name(s).
Example:
DROP VIEW Maximum
CREATE VIEW tMaximum AS SELECT (MAX(CHARGE)) AS MaximumCharge +
FROM TableName ...
For more details and examples on CREATE VIEW: http://www.RSyntax.com
Have Fun!
Very Best Regards,
Razzak.
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
