myles@... wrote:

> But I now need to change a property of that constraint (from 'No Update' to
> 'Cascade') in the case of a delete. When I attempt to make this change with
> IBExpert, I'm getting an error 'XXXXXX in use'
>
> What do I need to do to be able to make these sorts of changes and not
> encounter these errors?
>

1) Be the only user of the database
2) Don't reference either table before you make the change


Regards,


Ann