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;";
1检查相关数据库配置,qt数据库驱动
2验证sql语句是否正确,最好写个qt的demo验证