Creates a new #GdaSqlField structure, using parent
as its parent part.
a #GdaSqlStatementInsert, #GdaSqlStatementUpdate, #GdaSqlSelectField, #GdaSqlSelectTarget, #GdaSqlOperation
inheritance structure
not %NULL if expression is a CASE WHEN ... expression
not %NULL if expression must be cast to another data type
not %NULL if expression is a condition or an operation
not %NULL if expression is a function or aggregate
a #GdaSqlParamSpec, or %NULL if this is not a variable
not %NULL if expression is a sub select statement (#GdaSqlStatementSelect or #GdaSqlStatementCompound)
a #GValue, or %NULL. Please see specific note about this field.
Please see specific note about the value
field
Frees a #GdaSqlExpr structure and its members.
Creates a new string representation of the SQL expression. You need to free the returned string using g_free();
Sets the expression's parent to the #GdaSqlStatementSelect held by stmt
. After
calling this function stmt
is freed.
a #GdaSqlStatement holding the #GdaSqlStatementSelect to take from
Creates a new #GdaSqlField structure, using parent
as its parent part.
a #GdaSqlStatementInsert, #GdaSqlStatementUpdate, #GdaSqlSelectField, #GdaSqlSelectTarget, #GdaSqlOperation
This structure contains any expression, either as a value (the
value
part is set), a variable (theparam_spec
is set), or as other types of expressions.Note 1 about the'joe' value should be
"'joe'" and not "joe" .
value
field: if the expression represents a string value in the SQL statement, the string itself must be represented as it would be in the actual SQL, ie. it should be escaped (accordingly to the escaping rules of the database which will use the SQL). For example a string representing theNote 2 about the
value
field: if the expression represents an SQL identifier (such as a table or field name), then thevalue_is_ident
should be set to %TRUE, andvalue
should be a string which may contain double quotes around SQL identifiers which also are reserved keywords or which are case sensitive.