IF ((OLD.ID IS NULL AND NEW.ID IS NOT NULL) OR
      (NEW.ID IS NULL AND OLD.ID IS NOT NULL) OR
      (NEW.ID IS NOT NULL AND OLD.ID IS NOT NULL AND NEW.ID <> OLD.ID)) THEN
     INSERT INTO IBE$LOG_FIELDS (LOG_TABLES_ID, FIELD_NAME, OLD_VALUE, NEW_VALUE)
            VALUES (:TID, 'ID', OLD.ID, NEW.ID);

  IF (NEW.ID IS DISTINCT FROM OLD.ID) THEN
     INSERT INTO IBE$LOG_FIELDS (LOG_TABLES_ID, FIELD_NAME, OLD_VALUE, NEW_VALUE)
            VALUES (:TID, 'ID', OLD.ID, NEW.ID);

    sNonBlobFldTemplate = '  IF ((OLD.%FIELD_NAME_FORMATTED% IS NULL AND NEW.%FIELD_NAME_FORMATTED% IS NOT NULL) OR' + CRLF +
                            '      (NEW.%FIELD_NAME_FORMATTED% IS NULL AND OLD.%FIELD_NAME_FORMATTED% IS NOT NULL) OR' + CRLF +
                            '      (NEW.%FIELD_NAME_FORMATTED% IS NOT NULL AND OLD.%FIELD_NAME_FORMATTED% IS NOT NULL AND NEW.%FIELD_NAME_FORMATTED% <> OLD.%FIELD_NAME_FORMATTED%)) THEN' + CRLF +
                            '     INSERT INTO IBE$LOG_FIELDS (LOG_TABLES_ID, FIELD_NAME, OLD_VALUE, NEW_VALUE)' + CRLF +
                            '            VALUES (:TID, ''%FIELD_NAME_ASIS%'', OLD.%FIELD_NAME_FORMATTED%, NEW.%FIELD_NAME_FORMATTED%);';
    if (DatabaseProps['ServerVersion'] in (__svFB15, __svFB20, __svFB21, __svFB25)) then
    begin
      if (DatabaseProps['ServerVersion'] in (__svFB20, __svFB21, __svFB25)) then
        sNonBlobFldTemplate = '  IF (OLD.%FIELD_NAME_FORMATTED% IS DISTINCT FROM NEW.%FIELD_NAME_FORMATTED%) THEN' + CRLF +
                              '     INSERT INTO IBE$LOG_FIELDS (LOG_TABLES_ID, FIELD_NAME, OLD_VALUE, NEW_VALUE)' + CRLF +
                              '            VALUES (:TID, ''%FIELD_NAME_ASIS%'', OLD.%FIELD_NAME_FORMATTED%, NEW.%FIELD_NAME_FORMATTED%);';

      sBlobFldTemplate = ibec_StringReplace(sNonBlobFldTemplate, 'INTO IBE$LOG_FIELDS', 'INTO IBE$LOG_BLOB_FIELDS', __rfIgnoreCase);
      sBlobFldTemplate = ibec_StringReplace(sBlobFldTemplate, 'OLD_VALUE', 'OLD_BLOB_VALUE', __rfIgnoreCase);
      sBlobFldTemplate = ibec_StringReplace(sBlobFldTemplate, 'NEW_VALUE', 'NEW_BLOB_VALUE', __rfIgnoreCase);
    end;