Hi all,
I have developed an application with Delphi
with Firebird 1.5.2 that manage a lot of database files;
in each database my application store data for
different companies.

To update the structure of the databases, I use a
sql script where i have inserted all the sql command.

After each sql command there is a COMMIT WORK;
for example:

ALTER TABLE CUSTOMERS
ADD NEWFIELD VARCHAR(11);
COMMIT WORK;

In some cases when i run the scrit over each database,
for some database (not all), Firebird send this
error "unsuccesful metadata object XXXX is
un use".

In other cases, my application send an error message that
other users are connected to the database but the only connection
active is the program that run the script.

Please note that the above errors occurs random on some customers
and on some databases in single user or multi user environment.

For example one customer that manage 100 companies with 100
databases, have those error on 3 or 4 databases but other
customers don't have any problems.

Anyone know a solution to those problems ?

Thank in advance for the answers.

Massimo