>? SQLEXEC(lnHandle,"INSERT INTO MyTable (Field1) VALUES (10)") works fine, but
>
>lnVar=10
>? SQLEXEC(lnHandle,"INSERT INTO MyTable (Field1) VALUES (lnVar)")
>
>does not.
>
>I guess it´s because the server does not know that lnVar=10?
>
your right, you need to evaluate the variable on the client, not pass the variable name to the server:
? SQLEXEC(lnHandle,"INSERT INTO MyTable (Field1) VALUES (" + TRANSFORM(lnVar) + ")")
Erik Moore
Clientelligence