On 4/12/19, Jim Dossey <jim.dos...@gmail.com> wrote: > > The problem is when I do an INSERT and then try to SELECT that record by > rowid it doesn't find it.
Yes, because the SELECT is working inside a single transaction, but the INSERT is adding content in a separate, subsequent transaction which the SELECT never sees. This is by design. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users