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

Murray Cumming <[email protected]>
Newsgroups gmane.comp.gnome.db
Message-ID <1276433797.15135.92.camel@murrayc-x61>
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.

-- 
[email protected]
www.murrayc.com
www.openismus.com
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.