> When I run the script I get the following error message:
> Project Umpires.exe raised exception class EIBInterBaseError with message
> 'unsuccessful metadata update object UMPIRECLUBLINKS is in use'.
>
> This message is not too meaningful to me!

OK, I'll try to translate:

Umpires.exe is doing DDL to UMPIRECLUBLINKS, whilst there is another transaction still using UMPIRECLUBLINKS!

DDL is data definition language, that is CREATE/ALTER/DROP etc. and not DML (data modification language) which does SELECT/INSERT/DELETE etc. Firebird generally isn't too happy about modifying a table that is in use.

'Still using the table' might mean that that particular transaction wasn't committed/rolled back before the other was started. I think (not 100% certain) transaction settings determine whether the transaction containing DDL must have started after the commit/roll back or whether it is sufficient that the commit/roll back happened before the DDL statement.

HTH,
Set