You saved the day! On Mon, Nov 14, 2011 at 2:25 PM, Igor Tandetnik <itandet...@mvps.org> wrote:
> On 11/14/2011 5:03 PM, Matt Young wrote: > >> OK,I found the gotcha. I can swap out the target table in a view, but I >> cannot read the rowids from a view. >> > > You can, if you make them part of the view: > > create view MyView as select rowid, * from MyTable; > > It might be better though to give an explicit name to the rowid column in > your tables, by declaring a column as INTEGER PRIMARY KEY. For details, see > > http://sqlite.org/lang_**createtable.html#rowid<http://sqlite.org/lang_createtable.html#rowid> > > -- > Igor Tandetnik > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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