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
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users