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 _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
