Re: [gnome-db] SELECT DISTINCT with GdaSqlBuilder

[Vivien Malerba <vmalerba gmail com>]

On 29 March 2010 17:18, Murray Cumming <murrayc murrayc com> wrote:
> On Sun, 2010-02-28 at 11:49 +0100, Vivien Malerba wrote:
>> I'll implement these new methods ASAP.
>
> Thanks. I'm using that now.
>
> However, next I need a way to add GROUP BY parts to the SQL statement.
> Is there anything for that already?

No, I'll have to add it:
To set the HAVING condition:
void gda_sql_builder_select_set_having (GdaSqlBuilder *builder, guint cond_id);

To add a GROUP BY expression:
void gda_sql_builder_select_group_by (GdaSqlBuilder *builder, guint expr_id);

And maybe, to remove a GROUP BY expression:
void gda_sql_builder_select_ungroup_by (GdaSqlBuilder *builder, guint expr_id);

Vivien.