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?
Eduardo
-------- Mensaje original --------
*Asunto: *SV: [firebird-support] Unlock record
*De: *Svein Erling Tysvær [email protected]
[firebird-support] <[email protected]>
*Para: *[email protected] <[email protected]>
*Fecha: *20/01/2015 06:43
> 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.
HTH,
Set
---
El software de antivirus Avast ha analizado este correo electrónico en busca de
virus.
http://www.avast.com
