David,

Thanks for your 'view' to this (pun intended).

For a while I thought views that can't be opened with the View Designer are unreliable.

Regards
Dennis

>Dennis,
>
>The view designer is extremely limited, you should just code your more complex views with CREATE SQLView commands and forget about using the view designer, especially when it tells you it can't handle the view.
>
>The VFP8 designer has gotten better but it doesn't support UNION.
>
>>I usually use the View Designer to make my views. However, it doesn't have the UNION clause in it. So, I create a view MyViewWithUnionClause programatically which uses the UNION clause. Opening it in View Designer gives the message "SQL Too complex". The view works fine though.
>>
>>Two questions:
>>
>>1. Is the view 'safe' to use considering it was 'too complex' for the view designer?
>>
>>2. How can I programatically define the data type of the view parameter? We can do so in the View Designer.