On 26 February 2010 15:59, Piotr Pokora <[email protected]> wrote: > Vivien Malerba pisze: > > Hi! > >>> I am looking at GdsSqlStatementSelect diagram and hardly find how to set >>> multiple where conditions to Statement structure. >> >> You can only specify one GdaSqlExpr as the WHERE condition (the >> GdaSqlStatementSelect::where_cond), so if you need several condition, >> you need to create a GdaSqlExpr which acts as the "top level" AND or >> OR operation. There are various example in Libgda's code which >> illustrate how to set this up. > > What about expr->value of type string? Should I quote it explicitly? > gda_sql_identifier_add_quotes add double quotes, so I assume I should > take care of strings and quote them before setting expression value.
You don't need to quote anything, but you need to to: expr->value_is_ident = (gpointer) 0x1; to specify that the GdaSqlExpr holds an SQL identifier. See gda_sql_builder_add_id() in http://git.gnome.org/browse/libgda/tree/libgda/gda-sql-builder.c BTW, you should not use gda_sql_identifier_add_quotes() as it's marked as deprecated. Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
