Re: [sqlite] no errors,but not executed: Stored procedures in triggers

2006-03-24 Thread Jay Sprenkle
On 3/24/06, Chethana, Rao (IE10) [EMAIL PROTECTED] wrote: My problem is not with cascading or using recursive triggers. Actually, I am using sqlite3_create_function to execute some queries(like insert or update etc.) but the control does not pass to the custom function at all, ie., say a

RE: [sqlite] no errors,but not executed: Stored procedures in triggers

2006-03-24 Thread Chethana, Rao \(IE10\)
When I create trigger by giving select sp_dosomethingfunc(); THE TRIGGER IS GETTING CREATED without any errors stmts within main r executed, but stmts within this custom function- sp_dosomethingfunc(sqlite3_context *context, int argc,sqlite3_value **argv)-- r not excuted. Also what is that