add_field_value_id


Description:

[ Version ( since = "4.2" ) ]
public void add_field_value_id (SqlBuilderId field_id, SqlBuilderId value_id)

Valid only for: INSERT, UPDATE, SELECT statements

  • For UPDATE: specifies that the field represented by field_id will be set to the value identified by value_id.
  • For SELECT: add a selected item to the statement, and if value_id is not typeof ( unichar2)0, then use it as an alias
  • For INSERT: if field_id represents an SQL identifier (obtained using add_id): then if value_id is not typeof (unichar2)0 then specifies that the field represented by field_id will be set to the value identified by value_id, otherwise just specifies a named field to be given a value. If field_id represents a sub SELECT (obtained using gda_sql_builder_add_sub_select), then this method call defines the sub SELECT from which values to insert are taken.

See also add_field_value and add_field_value_as_gvalue.

Parameters:

this

a SqlBuilder object

field_id

the ID of the field's name or definition

value_id

the ID of the value to set the field to, or typeof ( unichar2)0