Skip navigation
Currently Being Moderated

SQLite Multiple rows insert

Apr 5, 2013 1:44 AM

Tags: #insert #multiple #row #sqlite

Hi,

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

http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-mu ltiple-rows-at-a-time-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-mu ltiple-rows-at-a-time-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:)

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points