> I'm trying to get my head around how this works. I have two tables where
> there is a foreign key relationship between the two tables. I've
> created a
> constraint to show this relationship and that works fine.
>
> 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?
>
> Myles

you must have a transaction open on one or more of the tables.
SQL Editor open? commit the transactions... better yet, close the SQL
Eidtors.
Next you might have browsed the data of the table(s) while clicking along
the top tabs. Try closing the tables, then re-open them but don't browse the
data before you try the constraint edit.
If all this fails and to be really quick, close all tabs (edit windows)
disconnect from the database and re-connect, but make sure you do not have
Delphi running with a query open against one of the tables. Check the
database properties, users to see how many connection you have open.
Alan