On 28 February 2010 00:06, Murray Cumming <[email protected]> wrote: > On Sat, 2010-02-27 at 14:45 +0100, Vivien Malerba wrote: >> 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 > > Thanks. > > What would expr_id represent? The rest of the SQL statement?
The @expr_id is the optionnal expression used when there is a "DISTINCT ON <expr>" construct. > >> 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) > > Again, thanks, though I don't know what the two IDs would be. They represent the limit count and offset. I'll implement these new methods ASAP. regards, Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
