Hi Szakály,
I do not know IBX nor why your code doesn't succeed (except that you create
TMP_ANY and delete TMP_AKARMI, but I guess this is just a typing error in
your mail), but I do know that every now and then newbies to Firebird
mention using temporary tables. In general they come from another database
where they've found them to be useful. However, in Fb it is generally
discouraged, and when the problem is discussed here in ib-support another
solution is found. So tell us why you think you need to create a temporary
table and then someone will tell you how to do things the Fb way.

HTH,
Set

At 12:06 02.12.2002 +0100, you wrote:

>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?