I tried what you said doing the following:

- Opened my application.
- Executed the option which locks a record (executes a SELECT * FROM TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).
- Opened the database with IB_SQL.
- Identified the record of MON$ATTACHMENTS table associated with my application.
- Try to delete this record.
- I got the error message "operation not supported".

Am I doing something wrong or I must do some other thing before deleting that record?

-------- Mensaje original --------
Asunto: Re: [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: 24/01/2015 11:50

 

>I saw the same as you, and made the following test:
>
>- Opened my application.
>- Executed the option which locks a record (executes a SELECT * FROM TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).
>- Opened the database with IB_SQL.
>- Looked in table MON$STATEMENTS. I found many records. Many of them with MON$SQL_TEXT null. Only one of them had MON$TIMESTAMP not null.
>- I deleted the only record with MON$TIMESTAMP not null.
>- I opened another instance of IB_SQL and verified that the record I locked at the first step was still locked.
>
>Am I undestanding something wrong or this doesn´t work?
>
>Another idea to manually unlock a record?
>
>Regards
>
>Eduardo

Finally got temporary access to a computer and can confirm that deleting from mon$statements is not enough when using WITH LOCK (I never use WITH LOCK myself). However, I did get access to this record (using Fb 2.5) by deleting from MON$ATTACHMENTS. There may or may not be other, less intrusive ways to get such access, though I failed when I tried MON$TRANSACTIONS.

Set

---

El software de antivirus Avast ha analizado este correo electrónico en busca de virus. www.avast.com