system.db.runPrepUpdate( query, args, [database], [tx], [getKey], [skipAudit])
String query - A query (typically an UPDATE, INSERT, or DELETE) to run as a prepared statement with placeholders (?) denoting where the arguments go.
List[Any] args - A list of arguments. Will be used in order to match each placeholder (?) found in the query.
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 prep update 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