"Not an error" is SQLITE_OK. Are you sure that you don't do anything
between getting error code from SQLite and obtaining error message?
Maybe in another thread?
Pavel
On Fri, Jun 5, 2009 at 3:50 AM, Vladimir Kharitonov <r...@kharitonov.info>
wrote:
> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
