Re: [sqlite] "not an error" error inserting data trough a view on fts3 table

Jay A. Kreibich wrote: > > you can create a trigger that fires on an attempt to > DELETE, INSERT, or UPDATE a view and do what you need > in the body of the trigger. > > Jay, this is exactly what the OP did. He has two tables and a view, and inserts into the two

Re: [sqlite] "not an error" error inserting data trough a view on fts3 table

I tried the scripts with the command line sqlite3 application. The row inserted in the data_view. But I received “SQL error: unknown error.” Pavel Ivanov-2 wrote: > > "Not an error" is SQLITE_OK. Are you sure that you don't do anything > between getting error code from SQLite and obtaining

Re: [sqlite] "not an error" error inserting data trough a view on fts3 table

On Fri, Jun 05, 2009 at 11:50:02AM +0400, Vladimir Kharitonov scratched on the wall: > I have a problem inserting data through a view. > INSERT INTO data_view (id, created, content) > VALUES (randomblob(16), datetime('now'), 'data'); > > I receive strange SQLite Error: ???not an error???. > I

Re: [sqlite] "not an error" error inserting data trough a view on fts3 table

"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 wrote: > I have a problem inserting data through a

[sqlite] "not an error" error inserting data trough a view on fts3 table

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