Hi! >>> It's possible using gda_sql_builder_select_add_target_id() with a >>> minor correction I've made, >>> see >>> http://git.gnome.org/browse/libgda/commit/?id=9b8778a08ffad208d8da159643b38d0f61482c6b >> >> Is it possible to do this in 4.0.x without GdaSqlBuilder? > > I'm sure it's possible if you just write the correct SQL. All > GdaSqlBuilder does is help you to write the SQL.
There's no GdaSqlBuilder in 4.0.x, so I use GdaSql structures directly. >> If not, can I just create SQL string and parse later? > > I don't understand this part. stmt is built with GdaSqlStatement, GdaSqlExpr, GdaSqlOperation, etc. So I assume I need to get sql string using gda_connection_statement_to_sql, and add it, to manually created sql as subquery. And then, parse it with gda_sql_parser_parse_string to create new statement which can be passed to connection's execute. The latter is not nice, and I wonder if I could follow GdaSqlBuilder implementation from 4.1.x to provide the same functionality in 4.0.x. However, in such case I am bit blind cause I am not sure what should be expression and what operation. Piotras _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
