SQLite Forum

Inserting multiple rows in table
Login
Issue resolved. There were 'not null' column constraint violations toward the end of the 2860 row data file. Modifying the file so each line is a separate 'insert into ...' statement resulted in sqlite printing the row number and specific error rather than the above.

Fixed the errors, deleted table rows, and re-read the data table via indirection. All's well now.

Thanks everyone for your comments.

Stay healthy.