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
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao