>Thru the View Designer I created v_man with this SQL:
> SELECT *;
> FROM glass!itmlayer;
> WHERE Itmlayer.process = "x";
> OR (Itmlayer.process = "y");
> OR (Itmlayer.process = "z")
>
>If I take this SQL and put it in a prg:
> CREATE VIEW v_man as ;
> SELECT *;
> FROM glass!itmlayer;
> WHERE Itmlayer.process = "x";
> OR (Itmlayer.process = "y");
> OR (Itmlayer.process = "z")
>
>and run it, then go back in and look at the SQL thru the View Designer the SQL is:
> SELECT *;
> FROM glass!itmlayer;
> WHERE Itmlayer.process = "x";
> OR (Itmlayer.process = "y";
> AND Itmlayer.process = "z")
>
>Is this a BUG?
>
>You may be asking why create a view with code? I have need to create a view thru code because the view designer is truncating my where clause. There must be some limitation I'm hitting. Attempting to create the view thru code is failing because VFP is screwing up my SQL.
>
>Would someone be willing to check out if this is indeed a BUG?
Kim
If you mean 3.0 then I believe I remember hearing something about a bug. A number of people I know use the View designer only to get the basics & then edit the code. They cannot get the power they need through the designer alone.
HTH,
Tom