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...@qt-project.org > [mailto:interest-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 '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@qt-project.org > http://lists.qt-project.org/mailman/listinfo/interest _______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
