On 9/6/2013 12:51 AM, techi eth wrote:
I am not sure if my problem I have stated clearly, found below detail explanation!!!---------------------------------------------------------------------------------------- Process 1: Handler1 = OpenConn(); Sqlite_Createfunc(Handler1, my_notifier_function()......); CREATE TRIGGER Event_test1 AFTER Update ON test BEGIN SELECT my_notifier_function(); END; ---------------------------------------------------------------------------------------- Proecss2: Handler2 = OpenConn(); Update test SET value;
That last statement will fail with "unknown function 'my_notifier_function' " error.
In this scenario when proecss2 will do update...
In this scenario process2 will be unable to do update.
If above will not happen then please suggest what is best I can get from sqlite3 to handle this kind of scenario.
Once again: there is no mechanism built into SQLite that would allow one process to be automatically notified that another process made a change to the database. Which part of this sentence did you find unclear the first time round?
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
