SqlBuilder.addFieldValueId

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 gda.sql_builder.SqlBuilder.addId): 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 gda.sql_builder.SqlBuilder.addSubSelect), then this method call defines the sub SELECT from which values to insert are taken.</para></listitem> </itemizedlist>

See also gda.sql_builder.SqlBuilder.addFieldValue and gda.sql_builder.SqlBuilder.addFieldValueAsGvalue.

class SqlBuilder
void
addFieldValueId

Parameters

fieldId gda.types.SqlBuilderId

the ID of the field's name or definition

valueId gda.types.SqlBuilderId

the ID of the value to set the field to, or 0