If you write a function in C, and register it with
sqlite3_create_function (or one of its variants), you can then have a
trigger like so:
CREATE TRIGGER Event_test1 AFTER INSERT ON test
BEGIN
SELECT my_notifier_function();
END;
And since it's a C function, you can do pretty much anything you want at
that point.
Peter
On 7/21/2013 10:32 PM, techi eth wrote:
I want to create a trigger on INSERT & in trigger logic I want to notify
other running executable in system.
Can I do this using trigger operation?
Example:
Create table ();
CREATE TABLE test (
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
);
CREATE TRIGGER Event_test1 AFTER INSERT
ON test
BEGIN
<Notify to other process either by registered callback OR signal>
END;
]1
C1heers
Techi
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
