update_row_in_table_v


Description:

[ Version ( since = "4.2.3" ) ]
public bool update_row_in_table_v (string table, string condition_column_name, Value condition_value, SList<string> col_names, SList<Value?> values) throws Error

col_names and values must have length (&gt;= 1).

This is a convenience function, which creates an UPDATE statement and executes it using the values provided. It internally relies on variables which makes it immune to SQL injection problems.

The equivalent SQL command is: UPDATE &lt;table&gt; SET &lt;column_name&gt; = &lt;new_value&gt; [,...] WHERE & lt;condition_column_name&gt; = &lt;condition_value&gt;.

Parameters:

this

an opened connection

table

the table's name with the row's values to be updated

condition_column_name

the name of the column to used in the WHERE condition clause

condition_value

the condition_column_type's GType

col_names

a list of column names (as const gchar *)

values

a list of values (as Value)

Returns:

TRUE if no error occurred, FALSE otherwise