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 user-defined function
>
> sp_dosomethingfunc(sqlite3_context *context, int argc,sqlite3_value
> **argv)
> {
> Do something or execute some queries.......
> ..................................etc
> }
>
> /* from main() I'm calling the above function using
> sqlite3_create_function*/
> int main()
>
> {
> /* after using sqlite_open */
>
> sqlite3_create_function(............)
>
> /* exec function is executed, but control is
> not passed to sp_dosomethingfunc, how do I make stmts inside this custom
> function get executed? */
>
> sqlite3_exec(.........)
> }
>
> /* and this sp_dosomethingfunc, I'm calling from triggers. I'm not
> getting any error. But this function is not executed */
your function would be executed by something like
select sp_dosomethingfunc
Since it's a function you have to do something to evaluate it.
Since your trigger is 'calling' the function, are you sure your
trigger is being run?
