Syntax error if >1 SET in executeUpdate()

[jeanDB]

Hello. I am using SQLite via ODBC in Calc/Basic. I am trying to update database records with com.sun.star.sdbc. I can update one field only in a single ‘executeUpdate’ statement, more than one SET=xxx creates a syntax error and I can’t see why. Can anyone advise please?

THIS WORKS:

stmt.executeUpdate(“UPDATE statements_ca SET notes = ‘uk’ WHERE id=2”)

THIS WORKS:

stmt.executeUpdate(“UPDATE statements_ca SET nominal = 160 WHERE id=2”)

But putting both SETs in one statement FAILS:

stmt.executeUpdate(“UPDATE statements_ca SET notes = ‘uk’, SET nominal = 160 WHERE id= 2”)

WITH THIS ERROR MESSAGE:

Error 1: An exception occurred
Type: com.sun.star.sdbc.SQLException
Message: near “SET”: syntax error (1). (line : 16

Thanks

[jeanDB]

Sussed it. Only a single ‘SET’ required for all field values, not a ‘SET’ for each field.