sqlite and "updatetrigger"

From: zacky azoulay (zacky.azoulay_at_sap.com)
Date: 11/28/04 

Date: 28 Nov 2004 08:20:47 -0800

Hi,

is there any option to open two tcl process (command prompt) working
on the same database.

then if one process is update the database the other get the trigger?

I saw the an example but it work on the same process only.

% package require sqlite
2.0
proc updatetrigger {table id} {
     puts "$table . $id updated"
}
sqlite db /test.db
db function updatetrigger updatetrigger
db eval "CREATE TABLE test (ID INTEGER PRIMARY KEY, STR VALUE)"
db eval "CREATE TRIGGER updatetrigger AFTER UPDATE ON test BEGIN
SELECT updatetrigger('test',old.ID); END"
db eval "INSERT INTO test VALUES(1,'a')"
db eval "UPDATE test SET STR='b'"

thank zacky