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

Your string is more 255 Characters.
Most probably it has to do with the text wrapping
or
use
TEXT [TO VarName [ADDITIVE] [TEXTMERGE] [NOSHOW] [FLAGS nValue] [PRETEXT eExpression]]
   TextLines
ENDTEXT
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform