Re: [gnome-db] gda_sql_builder_select_order_by()

On 27 April 2010 17:38, Murray Cumming <murrayc murrayc com> wrote:
> I'm trying to use 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,
> 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().


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]