Peter,

Try this:

lnVar=10
? SQLEXEC(lnHandle,[INSERT INTO MyTable (Field1) VALUES (?lnVar)])



>? SQLEXEC(lnHandle,"INSERT INTO MyTable (Field1) VALUES (10)") works fine, but

>lnVar=10
>? SQLEXEC(lnHandle,"INSERT INTO MyTable (Field1) VALUES (lnVar)")