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

Reply via email to