[sqlite] Read/write loops

Ken, In setting up sample code I have found a problem, in that the update connection was (depending on some buggy code) sometimes being opened "READ ONLY". Having corrected this I can get through 3 inserts before an error occurs "contraints failed". From what I can determine so far it looks l

[sqlite] Read/write loops

Ken, I am not sure how to use this facility, looks like one responds by sending another email. When you write "use transactions", do you mean "BEGIN TRANSACTION" / "COMMIT TRANSACTION". I am using these SQL commands to achieve transaction control. The first write is accepted, but the second o

[sqlite] Read/write loop

I get an error "database is locked" or "database read only" when attempting to update a table in the database. I have been reading various articles about this but cannot get a definitive answer from the conflicting discussions. Is it possible (on Windows 2000 using SQLite 3_5_6) to be reading fro