>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

Hi Jaime,
I have SET ENGINEBEHAVIOR set to 70...See Tamor Granor's reply and my reply to her below.