Try:
? SQLEXEC(lnHandle,"INSERT INTO MyTable (Field1) VALUES (" + transform(lnVar)+")")


>? 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?
>
>VFP documentation is rather sketchy, or non existing, on this issue.
>
>Does anybody know the solution.
>
>Regards
>
>Peter