>I looked in a database, and in MON$STATEMENTS tabla I have the following fields:

MON$STATEMENT_ID
MON$ATTACHMENT_ID
MON$TRANSACTION_ID
MON$STATE
MON$TIMESTAMP
MON$SQL_TEXT
MON$STAT_ID

>How can I detect which is the record I have to delete to unlock my record? This is the only table I have to modify?

I typically just look at the mon$sql_text with a mon$timestamp that seems to be the correct one.

HTH, Set

-------- Mensaje original -------

>> May be I can modify or delete some record in any MON$ table or do some other thing?

>I typically locate and delete records from MON$STATEMENTS. Mind you, that is 2.5 and typically when I have a long-
>running query. Don't know whether deleting from this table is possible or safe with 2.1 or sensible WITH LOCK.