Re: [gnome-db] GdaSqlQuery: sub-queries

Vivien Malerba <[email protected]> Wed, 12 May 2010 12:36:37 +0200

Newsgroups	gmane.comp.gnome.db
Message-ID	<[email protected]>

On 12 May 2010 12:25, Murray Cumming <[email protected]> wrote:
> In Glom I have a generic function like so:
> int count_rows_returned_by(const std::string& sql_query)
> {
>  std::string query_count =
>    "SELECT COUNT (*) FROM ("
>    + sql_query
>    + ") AS glomarbitraryalias";
>  ...
> }
>
> So with GdaSqlBuilder, is there any way to use a sub-query as the
> target? gda_sql_builder_select_add_target_id() seems to be only for
> specifying tables as targets:
> http://library.gnome.org/devel/libgda/unstable/GdaSqlBuilder.html#gda-sql-builder-select-add-target-id
>

I'll check this ASAP.

Vivien