Sqlite multipule row insert question

[ChrisW67]

Line 39 should be

db.next()

db.next()

To copy to clipboard, switch view to plain text mode 

like your original code shouldn't it?

The message regarding violation of a constraint can only be coming from the insert. Duplicate primary key value would be the first place to look although there can be other constraints defined on the reporttemplates table. It's not clear which (if any) column is a unique identifier for a row. If you are not inserting a value into any primary key column, and it is not an auto-increment type field, then the second row insert will have the same id as the first (e.g. NULL, 0 or empty) and fail.