SQLite Forum

Inserting multiple rows in table
Login
Larry,

The problem is not a brace rather than a parenthesis, it's the limit on the number of rows that 3.31.1 accepts, about 4.

When I try to insert more than 4-5 rows I get the error of a problem near line 1 near '('. But, when I enter have a single line, or a couple of lines, there's no problem. I discovered this when I tried populating the Sites table with 61 rows of data. Each time I had more than about 4 rows (and I don't remember the specific number of rows) the error was generated. When I cut it back to 1-3 rows they were inserted with no problems. And, each line but the last terminates with a comma.

So, now on my large data files I'll make each row a separate insert into statement. But, that's after a 1.5 hour conference call I have coming up.

Thanks