Ooops....
I thought that you were union-ing the to select statements.
I realized after I sent it.....
Ben
----- Original Message -----
From: "Ben Petersen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 10:47 AM
Subject: Re: Union in view crashes report
> 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
> > >
> > >
> >
> >
> >
>
>
