Hi,
Could you suggest me what's wrong in this code?
'** Save new data in another table ****
strSQLSave = "INSERT INTO _ProtocolloAmm (IDPro, InOut, Azienda,TipoDoc, DataPro, MittenteDestinatario, DataDoc, NumDoc, ImportoDoc, CentrodiCosto, DataOut, DataIn, NumPro, FagQuery) values ("
'strSQLSave = "INSERT INTO _ProtocolloAmm (Azienda) values ("
'strSQLSave = strSQLSave & "3000" & ","
strSQLSave = strSQLSave & "" & ","
strSQLSave = strSQLSave & dict(keys(1)) & ","
strSQLSave = strSQLSave & dict(keys(0)) & ","
strSQLSave = strSQLSave & dict(keys(2)) & ","
strSQLSave = strSQLSave & dict(keys(3)) & ","
strSQLSave = strSQLSave & dict(keys(4)) & ","
strSQLSave = strSQLSave & dict(keys(5)) & ","
strSQLSave = strSQLSave & dict(keys(6)) & ","
strSQLSave = strSQLSave & dict(keys(7)) & ","
strSQLSave = strSQLSave & dict(keys(8)) & ","
strSQLSave = strSQLSave & dict(keys(9)) & ","
strSQLSave = strSQLSave & dict(keys(10))
strSQLSave = strSQLSave & ")"
response.write(strSQLSave)
dbConnection.Execute strSQLSave
thank you
Marcos