Jerry,
local xyz
xyz = 123
SQLExecWrapper( "insert into x values ( ?m.xyz ) " )
function SQLExecWrapper( lcSQL )
lnResult = SQLExec( gnHandle, lcSQL )
if ( lnResult < 1 )
aerror( gaSQLError )
endif
return
xyz is not a variable that is in scope when the function runs so the SQL engine will prompt you for the value.
>Thanks. I removed some of the fields to use as an example. The example that I used in my first message had an extra comma after the second field. Other than that, it is the same code.
>I tried declaring the memvars to private and that did not work.
>Also, not sure what you mean by the "variables not being in scope".