[Interest] QSqlQuery... bindValue does not work for CREATE TABLE .... AS SELECT....

[Bernhard]

Maybe these are interesting for you: 
http://stackoverflow.com/a/26451395/1421332
http://stackoverflow.com/q/26448906/1421332

-- 
Kind Regards
Bernhard Lindner

> -----Ursprüngliche Nachricht-----
> Von: interest-bounces+private=bernhard-lindner.de at qt-project.org
> [mailto:interest-bounces+private=bernhard-lindner.de at qt-project.org] Im
> Auftrag von Guido Seifert
> Gesendet: Dienstag, 10. März 2015 20:07
> An: interest at qt-project.org
> Betreff: [Interest] QSqlQuery... bindValue does not work for CREATE TABLE
> .... AS SELECT....
> 
> 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=(SELECT seriesid FROM
> > series WHERE series=:series AND version=:version) AND
> > titlegroup.titleID=title.titleID;";
> 
> Works fine when I replace :series and :version with concrete values. Now
the
> question is... is this supposed to work? Is it a bug?
> Or should it be ignored as some strange fringe use case and at best be
> documented?
> 
> Ok, there is also the remote possibility that I overlooked something or
made
> a mistake. ;-) The database I currently use is postgresql.
> 
> Guido
> 
> 
> _______________________________________________
> Interest mailing list
> Interest at qt-project.org
> http://lists.qt-project.org/mailman/listinfo/interest