Marshal

>
>A SQL View with a UNION clause which works just fine in VFP 7 will not Requery when initially opened with the NODATA clause.
>
>The View will open once but will bomb out with the VIEW DEFINITION ERROR when a REQUERY is attempted.
>
>If the View is opened without the NODATA clause everything works fine.
>
>Is this a VFP 8 Bug or a Feature?

First, if you SET ENGINEBEHAVIOR 70 , does the problem disapear?

Jaime