That was it. There was another SELECT going on that had not been finalized.
Thank you Richard, Simon, and Graham for you help on this. > On Apr 12, 2019, at 2:36 PM, Richard Hipp <d...@sqlite.org> wrote: > > On 4/12/19, Jim Dossey <jim.dos...@gmail.com> wrote: >> I'm doing the INSERT first, without a BEGIN ... COMMIT transaction, then I'm >> doing the SELECT. Shouldn't the INSERT do it's own COMMIT which should make >> the new row visible to the SELECT? Should I add a BEGIN ... COMMIT around >> the INSERT? > > Perhaps the SELECT is running inside of a transaction that was started > before you did the INSERT. For example, perhaps you didn't > sqlite3_finalize() the previous SELECT, which caused it to hold the > read transaction open. > > -- > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users