Skip navigation
Currently Being Moderated

SQLite Multiple rows insert

Apr 5, 2013 1:44 AM

Tags: #insert #multiple #row #sqlite


I know this question has been asked and there was an answer: 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: ltiple-rows-at-a-time-in-an-sqlite-database


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