GdaSqlBuilder and MAX statement

[Johannes Schmid-4]

Hi!

I converted some of the glom SQL statements to GdaSqlBuilder which
worked quite well. But now I ran into a problem. How can I create a
query which includes the MAX statement with GdaSqlBuilder, like this
one:

"SELECT MAX(table.field) FROM  table"

Thanks,
Johannes


_______________________________________________
gnome-db-list mailing list
gnome-db-list@...
http://mail.gnome.org/mailman/listinfo/gnome-db-list

[Vivien Malerba]

2009/9/30 Johannes Schmid <jhs@...>:
> Hi!
>
> I converted some of the glom SQL statements to GdaSqlBuilder which
> worked quite well. But now I ran into a problem. How can I create a
> query which includes the MAX statement with GdaSqlBuilder, like this
> one:
>
> "SELECT MAX(table.field) FROM  table"

It seems I forgot about functions at all in the GdaSqlBuiler API, so
it looks like you can't at the moment build such a statement. I'll
correct this ASAP, sorry for the inconvenience.

Vivien
_______________________________________________
gnome-db-list mailing list
gnome-db-list@...
http://mail.gnome.org/mailman/listinfo/gnome-db-list

[Vivien Malerba]

2009/9/30 Vivien Malerba <vmalerba@...>:

> 2009/9/30 Johannes Schmid <jhs@...>:
>> Hi!
>>
>> I converted some of the glom SQL statements to GdaSqlBuilder which
>> worked quite well. But now I ran into a problem. How can I create a
>> query which includes the MAX statement with GdaSqlBuilder, like this
>> one:
>>
>> "SELECT MAX(table.field) FROM  table"
>
> It seems I forgot about functions at all in the GdaSqlBuiler API, so
> it looks like you can't at the moment build such a statement. I'll
> correct this ASAP, sorry for the inconvenience.

This is now in the master branch, see
http://git.gnome.org/cgit/libgda/diff/samples/SqlBuilder/example.c?id=d0f88fbbe6e358b8e3cb141a65f771bb93198b75

Vivien
_______________________________________________
gnome-db-list mailing list
gnome-db-list@...
http://mail.gnome.org/mailman/listinfo/gnome-db-list

[Johannes Schmid-4]

Hi!

> >
> > It seems I forgot about functions at all in the GdaSqlBuiler API, so
> > it looks like you can't at the moment build such a statement. I'll
> > correct this ASAP, sorry for the inconvenience.
>
> This is now in the master branch, see
> http://git.gnome.org/cgit/libgda/diff/samples/SqlBuilder/example.c?id=d0f88fbbe6e358b8e3cb141a65f771bb93198b75
>

Thanks a lot!

Johannes


_______________________________________________
gnome-db-list mailing list
gnome-db-list@...
http://mail.gnome.org/mailman/listinfo/gnome-db-list