Hi,
I was trying out to test some trigger stuff, basically if I have 2 connections
open, and one of the connection registered a user defined function to be
invoked. Now when the other connection inserts into table was trying to see if
the first functions registered function is called or not.
I am having a trigger in this format,
CREATE TRIGGER trigs_partid_t01
AFTER INSERT
ON ids
BEGIN
SELECT foo_bar_trigs(new.mId);
END;
I have proper implementation for the foo_bar_trigs function registered in the
first function, and that is open always.
When I prepared a statement to insert in the second connection, while
preparing, I am getting an error as, "no such function: foo_bar_trigs".
Is it always necessary that the second function also need to have this function
registered, as I am not even able to prepare a statement, and its coming out
with this error.
...
Chetana.
____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com
