Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql as text
Message
De
17/04/2007 12:02:21
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Sql as text
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01216805
Message ID:
01216805
Vues:
63
Hi,
Can anyone help me explain why this does not work:
lSelect = 'Select bp_eng.engkod, bp_ten.t_szam, bp_ten.tcs_szam,;
 bp_ten.tipus, bp_ten.suly, bp_ten.ttav, bp_ten.kszam, bp_ten.ktav;
  From bp_eng LEFT JOIN bp_ten;
   ON ALLTRIM(bp_eng.engkod) ==  ALLTRIM(bp_ten.engkod);
   Where bp_eng.engkod == "UE00000106";
   into cursor temp2'
   
? AT('"',lSelect)
I get the message "Command contains unrecognized phrase...".
If I leave out the "Where..." clause, it runs all right.

Thanks
Tamas
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform