Try
create trigger itemDelTrg after delete on Items for each row begin
delete from Stats where Stats.ID = old.ID;
end;
Also consider
create trigger statInsTrg before insert on Stats for each row
when (select count(ID) from Items where ID = new.ID) = 0 begin
select raise(rollback, 'foreign-key violation');
end;
Also read <http://www.sqlite.org/lang.html#createtrigger> if you
haven't already.
Regards
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
