zhangx172(提问者)能个举个简单的例子吗?我的列名分别是“日期”“A”“B”“合计”,FR的两张填报分别填A和B,日期两张表里都有,是主键。现在我数据库添加触发器,选的是“更新”,语句是 UPDATE table SET 合计 = A + B;保存成功。这样我填报时填A提交成功,填B提交就不成功,提示:Can\'t update table \'test\' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.