Firebird - 获取触发器内所有修改的字段

Firebird - 获取触发器内所有修改的字段

sql
CREATE TRIGGER my_trigger
AFTER UPDATE ON my_table
FOR EACH ROW
AS
BEGIN
  -- 在这里添加触发器的逻辑代码
END

sql
FOR i IN 1 TO (SELECT RDB$FIELD_POSITION FROM RDB$TRIGGER_FIELDS WHERE RDB$TRIGGER_NAME = 'my_trigger')
DO
BEGIN
  SELECT RDB$FIELD_NAME FROM RDB$RELATION_FIELDS WHERE RDB$FIELD_POSITION = i INTO :field_name;
  -- 在这里处理被修改的字段
  SUSPEND;
END

sql
FOR i IN 1 TO (SELECT RDB$FIELD_POSITION FROM RDB$TRIGGER_FIELDS WHERE RDB$TRIGGER_NAME = 'my_trigger')
DO
BEGIN
  SELECT RDB$FIELD_NAME FROM RDB$RELATION_FIELDS WHERE RDB$FIELD_POSITION = i INTO :field_name;
  
  IF (:field_name = 'name') THEN
  BEGIN
    -- 如果被修改的字段是"name"，执行相应的逻辑
  END
  ELSE IF (:field_name = 'age') THEN
  BEGIN
    -- 如果被修改的字段是"age"，执行相应的逻辑
  END
  ELSE IF (:field_name = 'email') THEN
  BEGIN
    -- 如果被修改的字段是"email"，执行相应的逻辑
  END
  
  SUSPEND;
END