At 08:50 AM 10/01/2008, you wrote:

>Hello Everyone,
>I am trying to resolve an "unsuccessful metadata update object XXXX is
>in use" error message. Is there a way to retrieve a list of tables
>that firebird has open ?

Firebird doesn't "have tables open" or "open objects". It has transactions that have a configured degree of "interest" in database objects and their dependents. Your IBO applications have client transactions, from which you can deduce facts about tables that those transactions are interested in. What you can't do is find out facts about other clients' transactions.

Firebird 2.1 introduces the monitoring tables, from which a privileged Firebird user can find out information about all uncommitted transactions and active statements. However, I'm not aware that these will give any kind of "route" by which you could find out which tables or dependents have pages active in the cache or which PSQL objects are in the cache or which records in the database are "interesting" to other transactions.

>If so...this might help me to resolve my
>problem. We are using IBO 4.8 and Firebird 2.0.

The way to "resolve" the problem is not to let it happen in the first place. This is a multi-user database management system that is *designed* to protect consistency. Don't try to alter metadata objects while users are online.

Helen