OK,I found the gotcha. I can swap out the target table in a view, but I cannot read the rowids from a view.
So, do I have t, are rowids unavailable in a view? > > > On Mon, Nov 14, 2011 at 10:25 AM, Nico Williams <n...@cryptonector.com>wrote: > >> I thought nowadays SQLite3 was smart enough to re-prepare a prepared >> statement when the schema changes. >> >> Nico >> -- >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users