Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bad Transform Code
Message
De
17/08/2002 01:16:10
Rodolfo Novoa
Consultor Independiente
Tegucigalpa, Honduras
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Bad Transform Code
Divers
Thread ID:
00690667
Message ID:
00690667
Vues:
48
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform