>cCommand = "REPLACE "+cField+" WITH "+cValue+" "+cForClause
>&cCommand
>Are there any alternatives to this problem ??
This is exactly the type of situation where people are too quick to use macros.
REPLACE (lcField) WITH lvValue FOR (lcExpression)
works just fine.
Even if this didn't work, there is still SQL, and with a RUNSQL() function, we wouldn't need macros either.
Erik Moore
Clientelligence