>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?
>
>Thanks, Kim

Hi Kim,

I can not do anything about VFP changing your where clause, but maybe you could try this instead

SELECT *;
FROM glass!itmlayer;
WHERE Itmlayer.process IN ("x", "y", "z")

Maybe VFP will leave this one alone and you should get the same results.

Hope this helps.