Locked Record won't unlock

Startbeitrag von Paul Ziegler am 03.12.2008 15:16

I had a weird problem occur. A record was locked that should not have been. I quit both clients (using Classic mode) and restarted the app but the record was still locked. I used the command HLockRecNum(LFileName,hCurrentRecNum,hLockWrite) to lock the record and HUnlockRecNum(LFileName) to unlock it. the second command has to had run.

Is there a way to check and unlock, or simply run a procedure that will unlock all records for a single client? This way I could run a procedure to unlock all the possible records when something like this happens.

Thanks,

Paul

Antworten:

Hi Paul...

The only case I've seen of record not being unlocked (aside of course of a bug in my code :-) ) was when I had network problems (hardware or oplock configuration or any of those lovely problems)... In your case, if closing the app that originated the block didn't solve it, it's mostr certainly coming from the hardware or system...

so the right solution is probably to check all that, no try to find a software solution to hide it... This problem may cause other problems (index broken, or even corrupted data)

Best regards

Fabrice Harari
WinDev, WebDev, WinDev Mobile consulting

von Fabrice Harari - am 03.12.2008 18:03
Hello Paul

This has happened a couple of times to me in the past and the solution was to reboot the server which is a bit drastic.

If you cannot find the cause you could try this program

http://ccollomb.free.fr/unlocker/

Regards
Al

von Al - am 03.12.2008 21:41
Fabrice and Al,

Thanks for the responses. I will keep an eye on it.

Paul

von Paul Ziegler - am 03.12.2008 21:45
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.