project.org
> [mailto:interest-bounces+private=bernhard-lindner...@qt-project.org] Im
> Auftrag von Guido Seifert
> Gesendet: Mittwoch, 11. März 2015 10:43
> An: interest@qt-project.org
> Betreff: Re: [Interest] QSqlQuery... bindValue does not work for CREATE
> TABLE AS SELECT
&g
The error message is totally worthless (to me at least).
> "ERROR: syntax error at or near \"(\"\nLINE 1: EXECUTE (33)\n
> ^\n(42601)"
Does not make any sense since the same syntax works without bound values. It is
even the same error when I remove the subquery
and there is n
Hmm... how are those links supposed to help me? They are both about QSql::In
and QSql::Out and stored procedures.
Not applicable to my use case and problem. At least not in a way, which is
obvious to me. :-)
Guido
On Wed, 11 Mar 2015 08:49:36 +0100
"Bernhard" wrote:
> Maybe these are interest
Am Wed, 11 Mar 2015 10:29:41 +0100
schrieb Guido Seifert :
>
> > works at my side, qt4.8.6:
> > query.prepare("CREATE TEMP TABLE selectseriestable AS SELECT title FROM
> > titlegroup,title "
> > "WHERE titlegroup.seriesID=(SELECT seriesid FROM series WHERE
> > series=:series AND version=:
> works at my side, qt4.8.6:
> query.prepare("CREATE TEMP TABLE selectseriestable AS SELECT title FROM
> titlegroup,title "
> "WHERE titlegroup.seriesID=(SELECT seriesid FROM series WHERE
> series=:series AND version=:version) AND titlegroup.titleID=title.titleID;");
> QString series="bl
t-bounces+private=bernhard-lindner...@qt-project.org] Im
> Auftrag von Guido Seifert
> Gesendet: Dienstag, 10. März 2015 20:07
> An: interest@qt-project.org
> Betreff: [Interest] QSqlQuery... bindValue does not work for CREATE TABLE
> AS SELECT
>
> Hi,
> just 'disco
Am Tue, 10 Mar 2015 20:06:57 +0100
schrieb Guido Seifert :
> Hi,
> just 'discovered' that bindValue does not seem to work with CREATE TABLE
> statements. One could ask, why would anyone want to use
> a bound value in a CREATE TABLE statement. Here my query:
>
> > CREATE TEMP TABLE selectseriesta
Hi,
just 'discovered' that bindValue does not seem to work with CREATE TABLE
statements. One could ask, why would anyone want to use
a bound value in a CREATE TABLE statement. Here my query:
> CREATE TEMP TABLE selectseriestable AS SELECT title FROM titlegroup,title
> WHERE titlegroup.seriesID=(