FW: Error on Trigger

[Colin Findlay]

Hi there.

Anybody had this message from a PowerHouse routine?

> Data access error. (SYSTEM_STATUS_TBL*01)
> %RDB-E-TRIG_REQ_ERROR, error encountered by a request using triggers
> %RDMS-E-TRIGNODEL, trigger SS_TBL_TIDY cannot delete record being modified
> or
> stored
> %RDB-F-ON_DB, on database DISK$DRIVE7:[XDS.RDBDATA]XPS_MAIN.RDB;1
>  
> Press RETURN to continue.
> 
This happens when you update SYSTEM_STATUS_TBL such that it falls within the
confines of the following trigger:

>  
>  SQL> show trigger ss_tbl_tidy
>      SS_TBL_TIDY
>  Source:
>         SS_TBL_TIDY
>                      AFTER UPDATE ON
>                         SYSTEM_STATUS_TBL
>                         (
>                         DELETE FROM
>                                 SYSTEM_STATUS_TBL
>                         WHERE
>                      !          DATE_AMENDED <= CAST(CURRENT_DATE -
> INTERVAL '12' MONTH AS DATE ANSI)
>                                 DATE_AMENDED <= CAST(CURRENT_DATE -
> INTERVAL '1' YEAR AS DATE ANSI)
>                         )
>                         FOR EACH ROW 
> 
> 
.
Regards,
Colin
>  
>