On 4/12/19, Jim Dossey <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
