Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Object reference lost in SQL SELECT ?
Message
 
 
To
08/05/2006 15:46:10
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Miscellaneous
Thread ID:
01120146
Message ID:
01120284
Views:
15
Hi Tore,

First, the macro substitution stops at the first '.' (dot) not comma. Second, the rule applies to the macro substitution itself, not to the contents of the variable used in the macro substitution. There's no dot in the macro substitution in this case.
...
&SQLStatement
>Macro expansions stops at the first comma.
>
>lcSelect1=alltrim(object1.object2.property1)
>cSQLStatement = "SELECT column1, column2, eval(lcSelect1) as column3 
FROM cursor1 INTO CURSOR cursor2 READWRITE"
>
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform