At 22:37 06/04/2004 +0000, you wrote:

>Hello,
>
>I am currently working on a project where I create temp tables in a
>Firebird database, insert large number of records into the tables,
>copy records from temp tables to permanent tables, then drop the temp
>tables. At the end of the process there is >150000 records inserted.
>The problem is I get object is in use errors as shown below when
>removing some of the temp tables, although I made sure no other
>process can connect to the DB during the entire operation.
>
>
>ISC ERROR CODE:335544348
>
>ISC ERROR MESSAGE:
>no current record for fetch operation
>unsuccessful metadata update
>object TEMP_ORDERS is in use
>
>STATEMENT:
>TIB_DSQL: "<TApplication>.dmOrders.scrCleanup.<TIB_DSQL>."
>
>SQL ERROR CODE:-508
>
>SQL ERROR MESSAGE:
>The cursor identified in the update or delete statement is not
>positioned on a row.

Hi,

I think the connection that are using the object is YOUR current connection.

Try to commit before drop.... I think this should resolve the problem...

>...
>
>The funny thing is when looking at active users count with IB Expert
>there are 2 users shown, (SQL Server) and SYSDBA, where only 1
>(SYSDBA) should be shown. My question is what is this (SQL Server)
>user, and what process could possibly be connecting to the database
>with this username?

Have no idea... :(
There is a chance that someone created an user with that name ???

See you !


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.654 / Virus Database: 419 - Release Date: 06/04/2004


[Non-text portions of this message have been removed]