[gnome-db] GdaSqlBuilder: Specifying the full field name in a WHERE clause.
- From: Murray Cumming <murrayc murrayc com>
- To: GNOME-DB List <gnome-db-list gnome org>
- Subject: [gnome-db] GdaSqlBuilder: Specifying the full field name in a WHERE clause.
- Date: Tue, 25 May 2010 16:15:51 +0200
When specifying the fields to get, gda_sql_builder_select_add_field()
lets me specify both the table name and the field name, to avoid
ambiguity:
http://library.gnome.org/devel/libgda/unstable/GdaSqlBuilder.html#gda-sql-builder-select-add-field
But when I want to specify the field in a WHERE clause, or a JOIN, or a
function parameer, I must manually create that string, such as
"mytable"."myfield", with the quotes if necessary, when passing it to
gda_sql_builder_add_id():
http://library.gnome.org/devel/libgda/unstable/GdaSqlBuilder.html#gda-sql-builder-add-id
I'd like to have a function for field IDs that takes both strings. But
gda_sql_builder_add_field_id() already exists and has a very different
purpose:
http://library.gnome.org/devel/libgda/unstable/GdaSqlBuilder.html#gda-sql-builder-add-field-id
Maybe gda_sql_builder_add_id_for_field()?
--
murrayc murrayc com
www.murrayc.com
www.openismus.com
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]