Re: [sqlite] Memory DB - Query does not return all records after Update

Thank You for the help everyone. The problem was in my query. I have a trigger that updates the a "last_modified" field anytime there is an update on a given record. My query has a where clause that says ... last_modified < current_timestamp. So if there were any updates that occur during the

Re: [sqlite] Memory DB - Query does not return all records after Update

Oh, nice catch. Well, after I made the change I am still seeing the same issue. I added some print statements that will maybe help. It sounds like you might think it is because I am not closing my statement is the reason I am getting this issue? I was thinking if it were only that then no matter

Re: [sqlite] Memory DB - Query does not return all records after Update

COT_EVENT_TABLE = "CREATE TABLE MAIN_TABLE( pk char(41) primary key,\ item1 real, \ item2 char(64), \

Re: [sqlite] Memory DB - Query does not return all records after Update

Yes I believe so. For my UPDATES, currently (things have moved around quite a bit for me trying to solve this) sqlite3_exec(this->hDBC_, "BEGIN EXCLUSIVE TRANSACTION;", NULL, NULL, 0); sqlite3_prepare_v2(this->hDBC_, updateStatement, -1, >hStmt_, 0); sqlite3_bind_blob(this->hStmt_, 1, blob,

[sqlite] Memory DB - Query does not return all records after Update

I am using an in-memory database with a singleton containing a single connection. I have multiple threads (3) using this same connection, but I have ensured that only 1 thread uses the connection at a time. If I do an UPDATE on a record then immediately preform a SELECT, the query will return all