Subject Re: [firebird-support] ERROR ONLY FIREBIRD
Author Helen Borrie
At 02:18 PM 28/07/2004 +0000, you wrote:
>First, sorry for my bad english.
>I have a application for import COBOL data using TXT files (TXTs
>defined in GDB how EXTERNAL TABLES). After use Stored Procedures for
>the put this TXTs in tables DROP stored procedures and external
>tables. In Interbase6.0 it's ok. In Firebird 1.5.1 at DROP external
>tables, error!!! "Unsucessfull metadata ... table TXT_??? is in use".
>This error only in Firebird.
>Uncompatibility ??????????????

There certainly will be some. Firebird isn't InterBase. There are a lot of
unsafe IB 6 tricks that you can't do in Firebird 1.5.

>Resolutions???? How??? Please...

Commit all of the work done by the SP on the table and make sure the commit
didn't fail because of an exception. A failed transaction is still an
active transaction. Firebird won't let you drop something that is involved
in an active transaction.