I have a problem inserting data through a view.
This is my DB:
CREATE TABLE data (
id BLOB PRIMARY KEY,
created REAL NOT NULL
);
CREATE VIRTUAL TABLE text USING FTS3();
CREATE VIEW data_view AS
SELECT d.id, d.rowid, d.created, t.content
FROM data d INNER JOIN text t ON d.rowid = t.rowid;
CREATE TRIGGER data_view_insert INSTEAD OF INSERT ON data_view
BEGIN
INSERT INTO data (id , created) VALUES (new.id, new.created);
INSERT INTO text (docid, content) VALUES (last_insert_rowid(), new.content);
END;
When I insert rows in the data_view:
PRAGMA count_changes = 1;
INSERT INTO data_view (id, created, content)
VALUES (randomblob(16), datetime('now'), 'data');
I receive strange SQLite Error: “not an error”.
I use version 3.6.13
Any help?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
