Qt World Summit: Register Today!


  • 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
    i didn't found the SQLITE_LIMIT_COMPOUND_SELECT

Log in to reply