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

[Murray Cumming <murrayc murrayc com>]

On Tue, 2010-05-25 at 16:15 +0200, Murray Cumming wrote:
> 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()?

Thoughts? I might go ahead and implement this.

-- 
murrayc murrayc com
www.murrayc.com
www.openismus.com