[gnome-db] GdaSqlBuilder: Specifying the full field name in a WHERE clause.



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]