Quite good, but I read that "You cannot DELETE, INSERT, or UPDATE a view". I need to do that!
Is it possible to use triggers for this? Patrik On 02/19/2013 04:06 PM, Stephan Beal wrote: > On Tue, Feb 19, 2013 at 4:04 PM, Patrik Nilsson > <nipatriknils...@gmail.com>wrote: > >> (some alias command: abc is an alias of abc_v1 for this connection) >> >> select * from abc >> >> (The last command would then "select * from abc_v1".) >> > > How about: > > CREATE TEMPORARY VIEW abc AS SELECT * FROM abc_v1; > > e.g. > > sqlite> create temporary view x as select * from sqlite_master; > sqlite> select * from x; > sqlite> create table t(a,b,c); > sqlite> select * from x; > table|t|t|2|CREATE TABLE t(a,b,c) > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users