>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)")

George,

That´s it. Works like a charm. And it´s,(No offense to Larry and Erik),a lot less arcane than a bunch of TRANSFORM() statements with +´s and "´s and what not.
I wonder if one can use a similar approach in creating parameterized views on the server?

I am grateful to you all for taking the time to help out.

Peter