LS:DO-ODBC to connect to DB2 table and insert a row

[Foote]

I am connecting to a DB2 table using odbc in lotusscript.
I am using lotusscript to loop through a collection of documents in a notes database, saving data from several fields to temporary variables and then trying to insert a row into a db2 tble using those temporary variables.

My error message when I execute the qry is that dynamic variables cannot be used in the qry statement.
Is there a way to get around this?
my temporary variable is defined:
tpincode = doc.Pin1(0)
here is my qry statement:
qry.sql = "INSERT INTO WOWTB.FR_PIN_CODE VALUES(111111, :tpincode, '2004-07-30', '0000', '1111-11-11-11.11.11.111111')" Thanks....

 

[lespaul]

you're not structuring your query correctly:

qry.sql = "INSERT INTO WOWTB.FR_PIN_CODE VALUES(111111, " + tpincode + ", '2004-07-30', '0000', '1111-11-11-11.11.11.111111')"

result.Execute

Leslie

 

[Foote]

Leslie,
Thanks so much! My qry is now working. I couldn't find documentation anywhere on using the + signs.

 

[lespaul]

no problem! glad it's working,

les