0 Replies Latest reply on Apr 5, 2013 1:44 AM by Ibarim

    SQLite Multiple rows insert

    Ibarim Level 1

      Hi,

      I know this question has been asked and there was an answer:

      http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-tim e-in-an-sqlite-database

       

      But now things has changed, from version 3.7.11 SQLite does work normally with multiple insert:

      http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-tim e-in-an-sqlite-database

      http://www.sqlite.org/lang_insert.html

       

      Now the problem is that I use SQLite Expert to perform a multiple row insert with normal sql method:

      INSERT INTO table (col1, col2) VALUES

            ('row1col1', 'row1col2'), ('row2col1', 'row2col2'), ...

      And this works. However when I try to use this insert within Flash Builder it gives me an error - syntax error near ",".

       

      Is there a way I can check or update SQLite within Flex so I could use multiple row insert?

       

      Thanks in advance for answers:)