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

Reply via email to