Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql as text
Message
From
17/04/2007 12:02:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Sql as text
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01216805
Message ID:
01216805
Views:
64
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
Next
Reply
Map
View

Click here to load this message in the networking platform