kimon_the_athenian2 wrote:

>>I think that you may be running into yourself. Creating a foreign

> Thanks for the answer! The connection is made via Delphi dbExpress and
> at the time of creating the FK there is a *closed* dataset that queries
> from a table referenced in FK. Does a closed dbExpress dataset mean
> compiled statement?

Yes.

>
> The strangest thing is that one of my client ran this database updating
> script unsuccessfully, then closed the application and started again
> and then the script succeeded. At both cases there was only this closed
> dataset that could reference either of FK tables.

Closing the application and starting again will release the relation
existence lock that the connection holds to protect compiled requests
from unpleasant surprises.


Regards,


Ann