Kevin
Below is the actual script I am trying to run. I added the db connection at the end as shown in your example above, it failed. The script works if I run it on the default database connection. iI need to run it on another server database connection which is “Ignition_PLU”.
fpmi.db.runPrepStmt(“INSERT INTO Scrap_Scales (Mac_Code,Job,DtCategoryCode,DTCode,ScrapLbs,Source_Ref,REP_TIME) VALUES (?,?,?,?,?,?,?)”,
[Mac_Code,Job,DtCategoryCode,DTCode,ScrapLbs,Source_Ref,REP_TIME],“Ignition_Plu”)