add_field_value_id
Description:
public void add_field_value_id (SqlBuilderId field_id, SqlBuilderId value_id)
Valid only for: INSERT, UPDATE, SELECT statements <itemizedlist> <listitem><para>For UPDATE: specifies that the field
represented by field_id
will be set to the value identified by value_id
.
</para></listitem> <listitem><para>For SELECT: add a selected item to the statement, and if value_id
is
not 0, then use it as an alias</para></listitem> <listitem><para>For INSERT: if
field_id
represents an SQL identifier (obtained using add_id):
then if value_id
is not 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 add_sub_select),
then this method call defines the sub SELECT from which values to insert are taken.</para></listitem> </itemizedlist>
See also gda_sql_builder_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 0 |