I've got an application that uses SELECT WITH LOCK style queries to lock
records, all works great untill the program crashes with a record
locked, it will leave the record locked, is there a way to make firebird
unlock records that were locked by clients that are now disconnected
through crash or whatnot? Usually when I have trouble with locked
records, they go away when everyone has completely disconencted, or if I
shut down the database. Unfortunately neither of these solutions work
during work hours are there any other solutions to fixing this? I've
been contemplating writing a middleware app to interface with the
firebird database and my program and just handle record locking there so
that I can explicitaly unlock them, while I ultimately will do this, it
takes time and it would be nice if I could get a solution to this up sooner.