| Subject | Unlock record |
|---|---|
| Author | Eduardo |
| Post date | 2015-01-19T13:11:57Z |
Hello:
I have an application in Delphi that uses Firebird 2.1 SuperServer. For some operations I use a SELECT like the following:
SELECT * FROM TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK
As you can see, I use "WITH LOCK" to lock the record. Then, when the application executes a commit or a rollback, the record unlocks.
Sometimes happens that a user PC "hangs" and then the record remains locked. Then, the only solution I found is to tell every user to close the application and reinitiate Firebird service.
Is there a way to unlock the record without reinitiating Firebird service?
I usually use IB_SQL to manage Firebird databases. May be I can modify or delete some record in any MON$ table or do some other thing? Is this possible?
Regards
Eduardo
I have an application in Delphi that uses Firebird 2.1 SuperServer. For some operations I use a SELECT like the following:
SELECT * FROM TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK
As you can see, I use "WITH LOCK" to lock the record. Then, when the application executes a commit or a rollback, the record unlocks.
Sometimes happens that a user PC "hangs" and then the record remains locked. Then, the only solution I found is to tell every user to close the application and reinitiate Firebird service.
Is there a way to unlock the record without reinitiating Firebird service?
I usually use IB_SQL to manage Firebird databases. May be I can modify or delete some record in any MON$ table or do some other thing? Is this possible?
Regards
Eduardo
|
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
|