Hi!

I have a problem with drop table command.

I use borland dbExpress to connect Firebird server on Win2k. I connect
with only one connection to FB.

I must create a table to process any data and drop after prcessing.

BEGITRAN
CREATE TABLE TMP_ANY
COMMIT

BEGINTRAN
INSERT, DELETE, SELECT , etc... on TMP_ANY
COMMIT

Delete all opened dbExpress sql query, prepared command, etc.

BEGINTRAN
DROP TABLE TMP_AKARMI
COMMIT <- here i get 'Unsuccesful metadata update. The object is in
use.'

But there is not any other connection, or any opened, prepared sql.

How can-i drop table from code?

((((sorry my english))))
-----------------------
Szakály Balázs
szakalyb@...
www.microraab.hu
GSM: +36(30)9363639
Tel: +36(96)510738
Fax: +36(96)510719