کار با sqlite

[hamid_73]

trigger delete درون sqlite چه جوری نوشته میشه؟؟

[khokhan]

trigger delete درون sqlite چه جوری نوشته میشه؟؟
یه چیزی مثل این

CREATE TRIGGER Delete_B_trigger
AFTER DELETE ON A
FOR EACH ROW
BEGIN
DELETE FROM B WHERE fid = OLD.id;
END

منبع :

http://www.tutorialspoint.com/sqlite/sqlite_triggers.htm

و

http://www.sqlite.org/lang_delete.html