Subject Unsuccessful metadata update
Author Peter Bailey
G'day all

I am attempting to develop a script to
create a new table,
copy data to the new table from the old table and then
delete the old table.
The script is to be executed from within a Delphi 2007 program using
IBX, (2007), components and operating under Windows 7 Home Premium.
Firebird version is

The script was modelled on another script doing a similar job, which
worked successfully under Windows Vista, (which may or may not be relevant).

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!

The error is triggered by the copy statement and this statement is the
first reference in the script to UMPIRECLUBLINKS. The script has a
"liberal" number of COMMIT statements, especially at the end of each of
the major sections.

Run separately, each of the three major sections works just fine.

Any help in fixing this script will be most welcome.