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 tried passing the result of gda_sql_builder_compound_add_sub_select(),
but I think that's for something else. It resulted in a failed
G_VALUE_HOLDS_STRING() check.

-- 
[email protected]
www.murrayc.com
www.openismus.com


_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list

Reply via email to