I add some information to my previous mail. When I try to delete the
record of MON$ATTACHMENTS, the complete message I got is the following:
SQL ERROR CODE:-817
SQL ERROR MESSAGE:
The insert, update, delete, ddl or authorization statement cannot
be executed because the transaction is inquiry only
Any other idea to unlock a record?
-------- Mensaje original --------
*Asunto: *Re: [firebird-support] Unlock record
*De: *Eduardo <guse...@gmail.com>
*Para: *firebird-support@yahoogroups.com
*Fecha: *26/01/2015 00:10
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.tysv...@kreftregisteret.no
[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.
http://www.avast.com
