It's limitation of VFP View Designer. You can use Stephen Sawyer's editor from
http://wwww.geeksandgurus.com or eView from UT download section.
>I open de database and write the sentence :
>CREATE SQL VIEW "VISTA2" ;
> AS SELECT * FROM data1!table1 ;
> WHERE Table1.codigo = '11111' and ;
> ( table1.codigo > '8000' or table1.nombre > 'ALMIRA' or ;
> table1.nombre <= 'EL MENOR' )
>
>but to review the view , visual foxpro don't transform good the WHERE sentence. Visual Foxpro do that:
>
>SELECT * FROM data1!table1;
> WHERE Table1.codigo = "11111" AND Table1.codigo > "8000";
> OR (Table1.nombre > "ALMIRA");
> OR (Table1.nombre <= "EL MENOR")
>
>that is incorrect group.
--sb--