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 <[email protected]>wrote: > >> I thought nowadays SQLite3 was smart enough to re-prepare a prepared >> statement when the schema changes. >> >> Nico >> -- >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
