SqlExpr

Object Hierarchy:

Description:

[ CCode ( copy_function = "g_boxed_copy" , free_function = "g_boxed_free" , type_id = "gda_sql_expr_get_type ()" ) ]
[ Compact ]
public class SqlExpr

This structure contains any expression, either as a value (the value part is set), a variable (the param_spec is set), or as other types of expressions.

Note 1 about the 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 the <userinput>'joe'</userinput> value should be <userinput>"'joe'"< /userinput> and not <userinput>"joe"</userinput>.

Note 2 about the value field: if the expression represents an SQL identifier (such as a table or field name), then the value_is_ident should be set to true, and value should be a string which may contain double quotes around SQL identifiers which also are reserved keywords or which are case sensitive.

Namespace: Gda

Package: libgda-6.0

Content:

Creation methods:

public SqlExpr (SqlAnyPart parent)
Creates a new SqlField structure, using parent as its parent part.

Methods:

public SqlExpr copy ()
Creates a new SqlExpr structure initiated with the values stored in this.
public void free ()
Frees a SqlExpr structure and its members.
public string serialize ()
Creates a new string representation of the SQL expression.
public void take_select (SqlStatement stmt)
Sets the expression's parent to the SqlStatementSelect held by stmt.

Fields:

public unowned SqlAnyPart any
public unowned SqlCase case_s
public unowned string cast_as
public unowned SqlOperation cond
public unowned SqlFunction func
public unowned SqlParamSpec param_spec
public unowned SqlAnyPart select
public Value value
public bool value_is_ident