Re: [sqlite] Using triggers for notification

[Eric Scouten]

Thanks... that did it.

D. Richard Hipp wrote:

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;