Hi!

The VFP view designer cannot display the query correctly. It does not cover all different SELECT staement you might use. thuis you cannot create such queries in the View designer. You can, however, use the CREAET SQl VIEW command. this way opening the view in view designer will spoil the query. Or just will not open the view at all. Just try to create a view with SELECT ... UNION SELECT... statement. It will be created and you even will be able to make it updatable with some effort and playing around the DBSETPROP function calls. However, you will never open it in the View designer, because it cannot represent such query visually in the view designer.

There is also advanced view designer somewhere in the files section here at UT.

HTH.


>Hi all,
>I get an unknown error in creating sql view.
>Below is a sql statement issue by me:
>
>CREATE SQL VIEW report1 REMOTE CONNECTION connect1 AS SELECT * ;
> FROM vendor WHERE vcode>='H' and (vtype='T' or region='CA') ;
> ORDER BY vcode, vname
>
>And below is the sql statement created itself:
>(can be previewed when modify the sql view)
>
>SELECT * FROM vendor WHERE vcode>='H' and vtype='T' or (region='CA') ;
> ORDER BY vcode, vname
>
>The difference is the bracket : (vtype='T' or region='CA') do not
>correct, which generated as : (region='CA')
>This will cause a big difference in results generated.
>Can anyone explain this and how to correct it ?
>
>Thanks,
>Samuel