On Mon, 06 Sep 2004 12:17:07 +0300, Rami Saarinen <[EMAIL PROTECTED]> wrote: > Should I use triggers? But they seem limited as the only allow the > execution of SQL statements.. so I could have a separate table where > I'd collect the changed information and process the table after the > UPDATE. That sounds kludgey.
The combination of triggers and user-defined functions (UDFs) should let you do this, since your trigger SQL can call out to arbitrary native code via the UDF mechanism. http://sqlite.org/capi3ref.html#sqlite3_create_function has some overview information about registering your own functions with sqlite. Mike