update-statement()

This function runs a data-changing SQL statement a on the database represented by alias b. Placeholders in the form &parameterNumber in the statement are replaced by the values of parameters c to j. Characters required for valid syntax (for example, quotes around strings) must already be part of the statement.

If you run an INSERT statement and the target table has columns with automatically generated values, you can specify the names of these columns as a comma-separated list in k. This saves the generated values for later use in the Mapping.

The function returns the number of affected rows after execution. If m is set to true, it returns -1 in case of an SQL error. If k contains a list of column names, the function creates a list SQL_AUTOGEN_KEY. This list contains the values of the individual columns in the order defined in k.

NOTE:

In addition to the &parameterNumber notation, you can also use the notation for prepared statements in the form @parameterNumber:parameterType@. Prefer prepared statements, because they prevent SQL injection attacks. Within prepared statements, parameters replace only single values. You cannot use them to pass value lists for IN, table or column names, operators, sort orders, or complete SQL fragments.

Parameters

Examples

Assume a table zipcodes that contains the ZIP codes of Germany (an imaginary 20000 entries). The primary key is the column id with the autogen property. Each example is independent and is based on the same starting data in the table.

After the INSERT call, a list SQL_AUTOGEN_KEY is created. It contains the value 20001 of the newly generated primary key.