system.db.runUpdateQuery(query, [database], [tx], [getKey], [skipAudit])
String query - A SQL query, usually an INSERT, UPDATE, or DELETE query, to run.
String database - The name of the database connection to execute against. If omitted or "", the project's default database connection will be used. [optional]
String tx - A transaction identifier. If omitted, the update will be executed in its own transaction. [optional]
Boolean getKey - A flag indicating whether or not the result should be the number of rows affected (getKey=0) or the newly generated key value that was created as a result of the update (getKey=1). Not all databases support automatic retrieval of generated keys. [optional]
Boolean skipAudit - A flag which, if set to true, will cause the update query to skip the audit system. Useful for some queries that have fields which won't fit into the audit log. [optional]
Integer - The number of rows affected by the query, or the key value that was generated, depending on the value of the getKey flag.
Vision Client, Perspective Session