Can a sql update be done on a table in perspective

[ethomason]

Did you verify the database is getting updated? That’s where I would start. Also, system.db.runPrepUpdate returns an integer of the number of rows inserted so you can print that to the console to help narrow things down.

[Glen_Bennett]

Thanks again to everyone for the help. Had a few issues to work through with it this morning but I got it working. Here is the final working script.