UPDATE SET Query on PB actionPerformed component scripting

Ignition
,
1

Running the following script, everything seems to work except my UPDATE SET Query for t_stamp in table named prevent. See Below.

PB%20UPDATE%20SET%20Query
PB%20UPDATE%20SET%20Query1416×672 43.1 KB

Here is the MySQL error I get.

 Traceback (most recent call last):
 File "<event:actionPerformed>", line 16, in <module>
java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(UPDATE 
prevent SET (t_stamp) Values (?) WHERE id LIKE ?, [Tue Jan 21 12:57:27 PST 2020, 101.12], , , 
false, false)
caused by Exception: Error executing system.db.runPrepUpdate(UPDATE prevent SET (t_stamp) Values (?) WHERE id LIKE ?, [Tue Jan 21 12:57:27 PST 2020, 101.12], , , false, false)
caused by GatewayException: SQL error for "UPDATE prevent SET (t_stamp) Values (?) WHERE id LIKE ?": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(t_stamp) Values ('2020-01-21 12:57:27.166') WHERE id LIKE 101.12' at line 1
caused by MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(t_stamp) Values ('2020-01-21 12:57:27.166') WHERE id LIKE 101.12' at line 1
Ignition v7.9.4 (b2017082911)
Java: Oracle Corporation 1.8.0_231
2

That is not the syntax for an UPDATE.

system.db.runPrepUpdate("UPDATE prevent SET t_stamp = ? WHERE id = ?",[EntryTime,ID])

3

Perfect. Thank you so much for your assistance.