We have created a script for v14 using the database functionality now available in eggPlant. We are simply reading contents from the db and assigning them to a variable, then writing a new value to one of the fields.
The db is in Access and it DOES have a primary key set to the first column.
We are able to read from the database and display the contents correctly in the Log display using the following code:
//Setting the taxNum variable set taxNum to "000112222" //Setting up the DB set myDB to (type:"odbc",DSN:"eggPlantDSN",user:"",password:"") //Puts table into infoTable variable put table "CreatNewAccount" of myDB into infoTable //Finds the table record that matches the variable taxNum set clientInfo to the record of infoTable where TaxID is taxNum //Shows the clientInfo record log clientInfo
But when we attempt to write to the database using this command (which would appear immediately after the code above), we receive the attached error:
//Puts date into the Birthdate field of the client record put "1/1/1966" into clientInfo's Birthdate
I am also attaching a pic of the db in design mode showing the primary key set to the ‘ID’ Field Name.
Thanks for your help!