Re: [gnome-db] gda_sql_builder_select_order_by()

[Vivien Malerba <vmalerba gmail com>]

On 4 May 2010 17:00, Murray Cumming <murrayc murrayc com> wrote:
> On Tue, 2010-04-27 at 23:10 +0200, Vivien Malerba wrote:
>> On 27 April 2010 17:38, Murray Cumming <murrayc murrayc com> 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.
>
> Yes, that's what I was thinking. The attached patch should do that, but
> please check that it makes sense.
>

Patch applied to git/master, Thanks!

Vivien