>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only