Jerry,

I tried the following commands on MySQL database on a test table mytest.

m.filingid = "AAAA"
m.envno = "BBBB"
sqlEXEC1 = SQLEXEC(ras2Conn12, "INSERT INTO mytest (code, division) Values(?m.filingid, ?m.envno)")

It did not prompt for any values and inserted data in the table. It did not matter whether I use or omit LOCAL filingid, envno