sqlUpdate

Updates the specified record in a table or view.

Required Parameters

conn	The connection string or database URL
user	The database username
password	The database password
table	Table (or view) from where to delete the record.
new:*	The record attributes that will be used for the update.

Optional Parameters

driver	The JDBC driver class name, by default the Microsoft driver class name is used.
timeout	Timeout, in seconds, for the operation to complete. Zero (0) means no timeout. This attribute defaults to 60.
map:*	Optional column mappings. You must use this attribute if column names in the table are different from the ones that you provided.
rec:*	The record attributes that will be used for searching.
newtype:*	The data type of a specified attribute of the record. The allowed values are: String, Int, Float, Binary, Datetime.

Output Attributes

sql:affectedrows	The number of rows updated.
sql:table	The table affected by the update.