Oh, great, thanks for the pointer, will do, good to known.
On Mar 16, 2021, at 5:48 PM, Elvis Stansvik
mailto:elvst...@gmail.com>> wrote:
Yea, you can always use db.driver()->escapeIdentifier(x,
QSqlDriver::TableName) if you want to sleep a little better anyway.
Elvis
Den tis 16 mars 2021 kl
Yea, you can always use db.driver()->escapeIdentifier(x,
QSqlDriver::TableName) if you want to sleep a little better anyway.
Elvis
Den tis 16 mars 2021 kl 21:52 skrev Jérôme Godbout :
>
> Thanks, that was the problems, this is annoying, but I do create the query
> prepare with a String with arg
Thanks, that was the problems, this is annoying, but I do create the query
prepare with a String with arg (I known this is bad, but the tablename is
provided by inner code only, this is not user inputs of any sort).
On Mar 16, 2021, at 4:23 PM, Elvis Stansvik
mailto:elvst...@gmail.com>> wrote:
Den tis 16 mars 2021 kl 21:21 skrev Elvis Stansvik :
>
> Den tis 16 mars 2021 kl 20:19 skrev Jérôme Godbout :
> >
> > Hi,
> >
> > I’m trying to use the Sql with Sqlite with Qt. The database seem to be
> > working just fine, but I run into troubles with the bind value. The named
> > bind doesn’t s
Den tis 16 mars 2021 kl 20:19 skrev Jérôme Godbout :
>
> Hi,
>
> I’m trying to use the Sql with Sqlite with Qt. The database seem to be
> working just fine, but I run into troubles with the bind value. The named
> bind doesn’t seem to work (Qt 5.15.2, Mac OS):
>
> m_sql->m_create_table(m_database
Hi,
I’m trying to use the Sql with Sqlite with Qt. The database seem to be working
just fine, but I run into troubles with the bind value. The named bind doesn’t
seem to work (Qt 5.15.2, Mac OS):
m_sql->m_create_table(m_database);
m_sql->m_create_table.prepare(R"raw(CREATE TABLE IF NOT EXISTS
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=(
On 01/26/2014 09:24 PM, Igor Mironchik wrote:
Igor Mironchik schreef op 26-1-2014 16:29:
Hi.
I have some questions about database support in Qt 5.
First of all, is it safe to transfer a QSqlQuery instance from one
thread to another to process him in another thread. I.e. I want to
execute
On 01/26/2014 07:45 PM, arno wrote:
> Hi Igor,
>
> On 26-Jan-14 4:29 PM, Igor Mironchik wrote:
>> I have some questions about database support in Qt 5.
>>
>> First of all, is it safe to transfer a QSqlQuery instance from one
>> thread to another to process him in another thread. I.e. I want to
>>
On domingo, 26 de janeiro de 2014 22:24:58, Igor Mironchik wrote:
> > No, that is not safe. You can use database access from threads, but
> > every thread needs it own QSqlDatabase instance of the database
> > connection. The documentation states:
> > "A connection can only be used from within the
Igor Mironchik schreef op 26-1-2014 16:29:
Hi.
I have some questions about database support in Qt 5.
First of all, is it safe to transfer a QSqlQuery instance from one
thread to another to process him in another thread. I.e. I want to
execute SELECT query on "DB" thread and return a QSqlQu
> Hi Igor,
>
> On 26-Jan-14 4:29 PM, Igor Mironchik wrote:
>> I have some questions about database support in Qt 5.
>>
>> First of all, is it safe to transfer a QSqlQuery instance from one
>> thread to another to process him in another thread. I.e. I want to
>> execute SELECT query on "DB" thread
Igor Mironchik schreef op 26-1-2014 16:29:
Hi.
I have some questions about database support in Qt 5.
First of all, is it safe to transfer a QSqlQuery instance from one
thread to another to process him in another thread. I.e. I want to
execute SELECT query on "DB" thread and return a QSqlQuery
Hi Igor,
On 26-Jan-14 4:29 PM, Igor Mironchik wrote:
> I have some questions about database support in Qt 5.
>
> First of all, is it safe to transfer a QSqlQuery instance from one
> thread to another to process him in another thread. I.e. I want to
> execute SELECT query on "DB" thread and return
Hi.
I have some questions about database support in Qt 5.
First of all, is it safe to transfer a QSqlQuery instance from one
thread to another to process him in another thread. I.e. I want to
execute SELECT query on "DB" thread and return a QSqlQuery from that
thread to the GUI thread, where
After setting up a table model like this:
code is here [stackoverflow.com]
the content is displayed properly, but when I edit the data item then press
enter ,this error occurred :
QSqlQuery::value: not positioned on a valid record
when I close the application and restart it again ,I fo
On 9 April 2013 16:57, Scott Aron Bloom wrote:
> It will depend the server backend.. However in general, I have never been
> successful (not just in Qt, at all) in binding for “lists”
That's correct, a bound parameter can only hold a single value. There
are some evil tricks you can do however, fo
lto:interest-bounces+scott.bloom=onshorecs@qt-project.org] On Behalf Of
Witold E Wolski
Sent: Tuesday, April 9, 2013 8:35 AM
To: interest@qt-project.org
Subject: [Interest] QSQLQuery bindValue to SELECT WHERE IN
Trying to bind a value to :
SELECT * from features WHERE id IN (:ids)
I tried 2 vers
Trying to bind a value to :
SELECT * from features WHERE id IN (:ids)
I tried 2 versions:
First, build a list with the ids I want to select.
Creating a QList qlist;
Second version building a QString (i.e. "1,2,3")
Than I bind it to the query above
query.bindValue(":ids",qlist);
But unfortunate
26 matches
Mail list logo
