问题相关代码,这是在qt中使用的代码
sqlStrList << "CREATE TRIGGER File_Delete"
"AFTER DELETE ON FileInfo"
"FOR EACH ROW BEGIN"
"DELETE FROM SubsectionFileInfo WHERE TaskID = NEW.TaskID;"
"END;";
sqlStrList << "CREATE TRIGGER SubFile_Insert"
"BEFORE INSERT ON SubsectionFileInfo"
"FOR EACH ROW BEGIN"
"SELECT RAISE(ROLLBACK,'No this TaskID in FileInfo)"
"WHERE (SELECT TaskID FROM FileInfo WHERE TaskID = NEW.TaskID) IS NULL;"
"END;";