hamid_73
شنبه 10 خرداد 1393, 23:14 عصر
trigger delete درون sqlite چه جوری نوشته میشه؟؟
khokhan
شنبه 10 خرداد 1393, 23:43 عصر
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
vBulletin® v4.2.5, Copyright ©2000-1403, Jelsoft Enterprises Ltd.