[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

Re: [sqlite] Read/write loops

Colin Yes transactions are initiate by "Begin" and end with a "commit" Can you provide a more code example. As its not clear to me at what point your getting the error. The default behavoir of a Begin transaction does not immediately lock the database for write. Take a look at "BEGIN

[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