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





  • 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


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.