Use of SQLITE_LIMIT_COMPOUND_SELECT
-
Hi Everyone
I develop an application in Qt/QML for Symbian mobile I have SEVERAL insert with a single insert request (I work with a BD SQLITE) the request looks like
@INSERT INTO 'tablename' SELECT 'data1' AS 'column1', 'data2' AS 'column2'
UNION SELECT 'data3', 'data4'
UNION SELECT 'data5', 'data6'
UNION SELECT 'data7', 'data8'@my problem is that I insert a lot of line (1500) and I get the following error: too many terms in compound SELECT
I found it necessary to specify the attribute SQLITE_LIMIT_COMPOUND_SELECT
but I do not know how or where
Thank you in advance for your help -
Try "QSqlDatabase::setConnectOptions()":http://qt-project.org/doc/qt-4.8/qsqldatabase.html#setConnectOptions.
-
Thanks trollixx for your answer
i aleardy see this methode it gives only this option
QSQLITE_BUSY_TIMEOUT
QSQLITE_OPEN_READONLY
QSQLITE_ENABLE_SHARED_CACHE
i didn't found the SQLITE_LIMIT_COMPOUND_SELECT