Re: [sqlite] create a view and add a column

2009-09-10 Thread Griggs, Donald
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

[sqlite] create a view and add a column

2009-09-10 Thread Tim Michelsen
Dear SQLite users, I normally access SQLite databases behind abstraction layers or application GUIs. For a current application in a webapplication I need to generate a view and add a ID cloumn to that view. Is this possible? Could you point me to an example on how this is achieved? Thanks in