Dan,
If you post your view maybe someone will catch something.
How many tables does the view address?
I use views extensively. Nearly all use aliases, and it makes no
difference if queried from the R> or a report. I have, on occasion,
had to invest some time in the more complex views to optimize
them.
Ben Petersen
On 24 Sep 2001, at 15:39, 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
>
>
>
