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 use version 3.6.13
SQLite VIEWs are read-only.
From < http://sqlite.org/omitted.html >:
VIEWs in SQLite are read-only. You may not execute a
DELETE, INSERT, or UPDATE statement on a view. But
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.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Our opponent is an alien starship packed with atomic bombs. We have
a protractor." "I'll go home and see if I can scrounge up a ruler
and a piece of string." --from Anathem by Neal Stephenson
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
