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
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
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
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):
>
>
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
=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
[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
Hmm... how are those links supposed
Am Wed, 11 Mar 2015 10:29:41 +0100
schrieb Guido Seifert warg...@gmx.de:
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
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 priv...@bernhard-lindner.de wrote:
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=bla;
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
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 I
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 a
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 a
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
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 thread
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
execute
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
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
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 QListQVariant qlist;
Second version building a QString (i.e. 1,2,3)
Than I bind it to the query above
query.bindValue(:ids,qlist);
But
On 9 April 2013 16:57, Scott Aron Bloom scott.bl...@onshorecs.com 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
23 matches
Mail list logo