Environment versions
Network:
Windows 2003 Server
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only