qt 中使用sql 语言创建触发器，但是看数据库后发现根本没创建成功

Question

问题相关代码，这是在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;";

Answer 1

1检查相关数据库配置，qt数据库驱动
2验证sql语句是否正确，最好写个qt的demo验证