However, I want to give the same expression to SQLEXEC()... won't that need the "?"s?

lnID = 5
lcDate = {^ 2003/06/01}
lcName = [Johny "Shortie" Smith's kid, ]+"[25 yrs old]"
SQLEXEC( nConnHnd, "INSERT INTO MyTable ( TableID, Name ) VALUES ( ?lnID, ?lcName, ?lcDate )" )

The parameterization should handle encoding so that string concatination can be avoided.

However, when I try it that way, it doesn't seem to work either.

>Why do you need parameters in this case? Remove "?" and it'll work.
>
>>But this doesn't work:
>>lnID = 5
>>lcName = "Name"
>>INSERT INTO MyTable ( TableID, Name ) VALUES ( ?lnID, ?lcName )