Hello! $ sqlite3 SQLite version 3.6.20
sqlite> create table test (id INTEGER PRIMARY KEY, a text); sqlite> insert into test (a) values (1); sqlite> create view view_test as select rowid,* from test; sqlite> .header on sqlite> select * from view_test; id|id:1|a 1|1|1 Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users