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
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
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
"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
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
5 matches
Mail list logo