This worked in 3.2.8 but not in 3.3.1/2 ....
I delcare a function using sqlite3_create_function()...this takes 1 arg
, an integer and calls the usual
code to execute a 'select[ based on the integer as a key and does some
work based on the result.
I declare a temp trigger to call the above when certain columns are updated.
*When the trigger executes the result of th select is garbage.*
I call the same function outside the trigger and it works fine.
Is there some rule you cannot execute the code of the C API inside a
trigger?
Thx
Russ