Within post #6 of the following topic:
http://forums.testplant.com/phpBB2/viewtopic.php?t=2622
… the following code was noted as a way past the Try/Catch piece we had used
put clientInfo into clientInfoCopy -- make a copy not connected to the db
set clientInfoCopy's Birthdate to "12/11/1966"
add record clientInfoCopy to infoTable
So we adjusted our script and it is now as follows:
// Setting up the database
set myDB to (type:"odbc",DSN:"eggPlantDSN",user:"",password:"")
// Puts table values into variables
put table "CreateNewCerts" of myDB into dataTable
put table "ResultsTable" of myDB into resultsTable
// Setting up iterator for CreateNewCertsDB
set dataIterator to iterate over the records of dataTable
// Getting the record from the table
put dataIterator’s nextValue into currentData
put currentData into currentDataCopy
log currentDataCopy
// Adding a record to the Results Table
add record currentDataCopy to resultsTable
When we do that, all of the script runs correctly except for that last ‘add’ line, we get the following error (which I also attached):
Syntax error in INSERT INTO statement., SQLSTATE=42000
Thanks