Re: [gnome-db] SELECT DISTINCT with GdaSqlBuilder

On 27 February 2010 12:37, Murray Cumming <[email protected]> wrote:
> How can I use the DISTINCT keyword when creating a SELECT statement with
> GdaSqlBuilder?
>

You can't! It seems I forgot about that...
Here is the API I propose for that:

void gda_sql_builder_select_set_distinct (GdaSqlBuilder *builder,
gboolean distinct, guint expr_id)
with the last field optionnal if @distinct is TRUE, and ignored if
@distinct is FALSE

Also there is no API to set limits, so I propose:
void gda_sql_builder_select_set_limit (GdaSqlBuilder *builder, guint
limit_count_expr_id, guint limit_offest_expr_id)

If it's OK with you I'll add those methods ASAP.

Vivien