> I have to change temporarly the Delete-Rule of some Foreign
> Key-Constraints from No Action to Cascade. These settings are stored in
> the table RDB$REF_CONSTRAINTS. But when I want to change the settings
> with the following update, I always get an error:
> update RDB$REF_CONSTRAINTS set RDB$DELETE_RULE='CASCADE'
> Exists there a solution for my problem ?

This type of metadata alteration should be done using a DDL statement
instead of a hack to the system tables.

Please use IB-Support@egroups.com for your general IB support questions.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com