With the next version of SQLite (which will be released this week) you
will be able to write a trigger on deletion of dependent rows where
you will just call your function.
Pavel
On Tue, Oct 13, 2009 at 1:19 PM, Igor Tandetnik wrote:
> mwnn wrote:
>> i am using triggers to delete dependent rows
mwnn wrote:
> i am using triggers to delete dependent rows of a table when a
> referred row is deleted. Is there a way for me to let SQLite call a
> user-defined function for every row deleted in a trigger?
Well, you could write your trigger like this:
create trigger ... on delete ...
begin
Hi all,
i am using triggers to delete dependent rows of a table when a
referred row is deleted. Is there a way for me to let SQLite call a
user-defined function for every row deleted in a trigger?
Regards,
mwnn
___
sqlite-users mailing
3 matches
Mail list logo
