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
>
>
