Hello! CREATE TABLE test ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ); CREATE VIEW view_test as select * from test; CREATE TRIGGER view_test_insert instead of insert on view_test begin insert into test (id) values (NULL); end;
insert into view_test (id) values (NULL); select last_insert_rowid(); 0 select max(rowid) from test; 1 insert into view_test default values; Segmentation error 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
