add_field_value_id
Description:
[ Version ( since = "4.2" ) ]
public void add_field_value_id (SqlBuilderId field_id, SqlBuilderId value_id)
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 byvalue_id
. - For SELECT: add a selected item to the statement, and if
value_id
is nottypeof ( unichar2)
0, then use it as an alias - For INSERT: if
field_id
represents an SQL identifier (obtained using add_id): then ifvalue_id
is nottypeof (unichar2)
0 then specifies that the field represented byfield_id
will be set to the value identified byvalue_id
, otherwise just specifies a named field to be given a value. Iffield_id
represents a sub SELECT (obtained usinggda_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 |