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
---
El software de antivirus Avast ha analizado este correo electrónico en busca de
virus.
http://www.avast.com
