Regarding: "...I need to generate a view and add a ID column to that view. Is this possible?"
I may well not be understanding your question, Tim. If so, you may want to provide more information, such as what software you're using to speak to the database, do you work with SQL, etc. If you *are* working with sql, a VIEW is pretty much shorthand for a SELECT query. You create a view by simply prepending "CREATE VIEW myViewName AS" in front of your desired SELECT query. http://www.sqlite.org/lang_createview.html E.g. CREATE VIEW myViewName AS SELECT (Name, Address) FROM PeopleTable; To add a column to a view, the column must be in one of the tables in the SELECT, or otherwise calculated by the select. You drop the existing VIEW and create the new one. E.g. DROP VIEW myViewName; CREATE VIEW myViewName AS SELECT (Name, Address, ID) from PeopleTable; _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
