>Hi all,
>
>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?

I wonder if this is related to the type coercion that VFP 8 does in UNIONs.

Tamar