Thanks for clarification. My understanding:
Process creating notified function has to create trigger & do the other operation (Update, Insert and Delete) to get trigger logic execution. I understand it may not be in same sequence. Process can register function & create trigger, But trigger operation may come on run time .(All by using common sqlite handler...) >Which part of this sentence did you find unclear the first time round? It is all clear!!!! I was just checking for hint, if some one comes across to handle this kind of scenario by using combination of sqlite capability & application logic!!! On Fri, Sep 6, 2013 at 10:34 AM, Igor Tandetnik <i...@tandetnik.org> wrote: > 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<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
