[Interest] Is chaining of multiple SQL statements with bound values possible?

Guido Seifert wargand at gmx.de
Mon Mar 16 16:04:54 CET 2015


Hi,
my problem:

When I combine two sql statement in one QSqlQuery:
query("SELECT * FROM foo; SELECT * FROM bar");
it works ok.

But this does not seem to work when the statements have different bound values:

query("SELECT * from foo WHERE name=:foo"; SELECT * from bar WHERE name=:bar");
query.bindValue(":foo",xxx);
query.bindValue(":bar",yyy);

I always get an unspecified syntax error. The statement without the bound values works fine.

Any ideas?

Guido



More information about the Interest mailing list