>if anything it is another reason not to use the View designer - not views
>the view designer has several limitations - probably just another one of them
>I usually use the designer for simple views/queries or the skeleton for more complex ones
If I create a view with CREATE SQL VIEW and don't use the View Designer to edit it/or look at the SQL query code, does it still accept the criterea I wanted in the WHERE clause? If so, you have a point. If not, it means in this case I cannot use views.