>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.

Hi Rodolfo,

where are you getting the SQL code that you say is not grouped correctly? If from the View Designer, that is not reliable: use something like eView (available in the libraries here) to see what is really there.

Hank