guido.klapperich@... wrote:

>
> 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 ?
>

I would have thought the right way to go about this problem would be to drop the
original constraints and then apply new constraints. This task will be a lot
easier if you have named your constraints. Otherwise you will have to search
through the appropriate system table ( I forget which ) for the system generated
names.

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further