|Subject||Re: [firebird-support] Unlock record|
|Author||Svein Erling Tysvær|
>I looked in a database, and in MON$STATEMENTS tabla I have the following fields:MON$STATEMENT_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.
-------- 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.