> 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
