Hi Ben,
There are no variables in the view definition, the select with .vIdVal
was just an example to show that the view works fine for that type
of operation... but fails when driving the report. If I remove the union
from the view all is well.
Thanks though,
Ben Petersen
On 18 Apr 2001, at 17:48, Ben Johansen wrote:
> Hi Ben
>
> It has been my experience when you use variables in view that you need to
> wrap then in parenthesis
> i.e.. Sel * from viewName whe IDcol = (.vIdVal)
>
> Ben Johansen
>
> ----- Original Message -----
> From: "Ben Petersen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, April 18, 2001 4:11 AM
> Subject: Union in view crashes report
>
>
> > Hi all,
> >
> > RBW6.5+ build 1.89xRT03
> >
> > I have a report driven by a view. The report crashes, closing RBase
> > to the desktop, when the view includes "union sel..."
> >
> > Sel * from viewName
> > and
> > Sel * from viewName whe IDcol = .vIdVal
> > work fine,
> > but not when printing the report, which is pretty simple. If I remove
> > the union portion of the view the report prints w/o problem.
> >
> > Any ideas?
> >
> > TIA,
> >
> > Ben Petersen
> >
> >
>
>
>
