Re: [gnome-db] gda_sql_builder_select_order_by()

On 27 April 2010 17:38, Murray Cumming <[email protected]> wrote:
> I'm trying to use gda_sql_builder_select_order_by()
> http://library.gnome.org/devel/libgda/unstable/GdaSqlBuilder.html#gda-sql-builder-select-order-by
> to do something like
>  SELECT sometable.somefield, someothertable.somefield FROM sometable
>  ... (some JOIN that I can't be bothered to think of)
>  ORDER BY sometable.somefield
>
> How can I get the id of "sometable.somefield" to give to
> gda_sql_builder_select_order_by()?
>
> gda_sql_builder_select_add_field() lets's me specify the table and the
> field,
> http://library.gnome.org/devel/libgda/unstable/GdaSqlBuilder.html#gda-sql-builder-select-add-field
> but that doesn't return the generated ID.

I suppose then gda_sql_builder_select_add_field() could be made to
return the field ID. Otherwise you can use the
gda_sql_builder_add_id(builder, 0, "sometable.somefield") method and
use that ID in gda_sql_builder_select_order_by().

Vivien