| Subject | Re: SV: [firebird-support] Unlock record |
|---|---|
| Author | Eduardo |
| Post date | 2015-01-20T17:33:18Z |
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
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 svein.erling.tysvaer@... [firebird-support] <firebird-support@yahoogroups.com>
Para: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Fecha: 20/01/2015 06:43
Asunto: SV: [firebird-support] Unlock record
De: Svein Erling Tysvær svein.erling.tysvaer@... [firebird-support] <firebird-support@yahoogroups.com>
Para: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
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.
www.avast.com