GdaSqlStatementInsert

The statement is an INSERT statement, any kind of INSERT statement can be represented using this structure (if this is not the case then report a bug). <mediaobject> <imageobject role="html"> <imagedata fileref="stmt-insert1.png" format="PNG"/> </imageobject> <caption> <para> Example of a #GdaSqlStatement having a #GdaSqlStatementInsert as its contents with 2 lists of values to insert. </para> </caption> </mediaobject> <mediaobject> <imageobject role="html"> <imagedata fileref="stmt-insert2.png" format="PNG"/> </imageobject> <caption> <para> Another example of a #GdaSqlStatement having a #GdaSqlStatementInsert as its contents, using a SELECT to express the values to insert. </para> </caption> </mediaobject>

struct GdaSqlStatementInsert {

GdaSqlAnyPart any;

char* onConflict;

GdaSqlTable* table;

GSList* fieldsList;

GSList* valuesList;

GdaSqlAnyPart* select;

void* GdaReserved1;

void* GdaReserved2;

}

Members

Variables

GdaReserved1 void* GdaReserved1;
GdaReserved2 void* GdaReserved2;
any GdaSqlAnyPart any;: inheritance structure
fieldsList GSList* fieldsList;: list of #GdaSqlField fields which are valued for insertion
onConflict char* onConflict;: conflict resolution clause if there is one (such as "OR REPLACE")
select GdaSqlAnyPart* select;: a #GdaSqlStatementSelect or #GdaSqlStatementCompound structure representing the values to insert
table GdaSqlTable* table;: name of the table to which data is inserted
valuesList GSList* valuesList;: list of list of #GdaSqlExpr expressions (this is a list of list, not a simple list)

gda c types aliases

enums

structs