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 same 1s interval as the query, they were dropped. The issue was that I did not understand/relalize that the precision on the timestamps were 1s.
Once again, thank you for all the help, Mike -- View this message in context: http://sqlite.1065341.n5.nabble.com/Memory-DB-Query-does-not-return-all-records-after-Update-tp67267p67717.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
