Subject Re: [ib-support] External Files Locks...
Author Helen Borrie
At 11:12 AM 12-07-02 +0200, you wrote:
>Hi All:
>I have a database with some external files. First, while the aplication is
>running some proccess read and write to this externals files. Later, before
>close the APP, i 'm trying to compress this files to other directory, but i
>can´t do it, interbase still have locked this files.
>I'am using Interbase 5.6 under Windows 2000

Unfortunately, this is an old InterBase bug. I'm pretty certain it has
been fixed in Firebird 1 but perhaps someone else would confirm.

As I recall, the workaround is to disconnect the client from the database
before you start doing filesystem operations on the external file.

If by chance you are using Delphi to do filesystem things with this file,
you may still encounter problems, because Delphi (v.5 and below, at least)
tends to leave locks on files it accesses for some operations, even after
the file handle has been released.


All for Open and Open for All
Firebird Open SQL Database · ·