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:
01120222
Views:
10
>Macro expansions stops at the first comma.

Tore,

after some experiments, I realized that the fact that "Macro expansions stops at the first comma" does not really affect my example.

Note, that if I would have something like this:

&cSQLStatement.SomethingElse

then the dot in the middle would really have been a breaking point. HOWEVER, the dots I have are actually in the middle of the value of the cSQLStatement, and not in the middle of the expression in the line that starts with the "&".

To proove my point, the following ALWAYS works:

cSQLStatement = "SELECT column1, column2, alltrim(object3.property3) as column3 FROM cursor1 INTO CURSOR cursor2 READWRITE"
&cSQLStatement

OR

cSQLStatement = "SELECT column1, column2, alltrim(cursor1.column5 + cursor1.column6) as column7 FROM cursor1 INTO CURSOR cursor2 READWRITE"
&cSQLStatement



So, I guess the issue is still open...

Any other ideas?

Thanks!
Igor.
Previous
Reply
Map
View

Click here to load this message in the networking platform