Eric Scouten wrote:
I'm struggling with implementing a notification system using triggers
and custom functions. Here's what I'd like to accomplish: SQLite
notifies me for every time a row is inserted, updated, or deleted in a
given table. Here's how I've attempted it so far (so far for insertions
only):
CREATE TABLE foo( x, y, z );
CREATE TRIGGER foo_insert AFTER INSERT ON foo FOR EACH ROW
WHEN NEW.x > 0
BEGIN
SELECT notifyObservers( "insert", x ) FROM foo;
omit this ------------^^^^^^^^
END;
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565