Occasionally, I want to drop a table and remove the folder.  So, I

DropTable(tablename)  <--successful
DeleteFile('dbisam.lck') <-- not successful
Removedir(foldername) <-- not successful because file not deleted.

How can I delete the lock file?  Since there are not tables referencing it, why does the delete fail?

TIA,
John

On 3/3/2020 2:56 PM, John Taylor wrote:
> Occasionally, I want to drop a table and remove the folder.  So, I
>
> DropTable(tablename)  <--successful
> DeleteFile('dbisam.lck') <-- not successful
> Removedir(foldername) <-- not successful because file not deleted.
>
> How can I delete the lock file?  Since there are not tables referencing it, why does the delete fail?

This is engine level lock file so you need to fully shut down all the
DBISAM sessions - close open databases sessions before you delete.


Raul

Raul wrote:

On 3/3/2020 2:56 PM, John Taylor wrote:
> Occasionally, I want to drop a table and remove the folder.  So, I
>
> DropTable(tablename)  <--successful
> DeleteFile('dbisam.lck') <-- not successful
> Removedir(foldername) <-- not successful because file not deleted.
>
> How can I delete the lock file?  Since there are not tables referencing it, why does the delete fail?

This is engine level lock file so you need to fully shut down all the
DBISAM sessions - close open databases sessions before you delete.

That's what I was afraid of, not really doable from a practical standpoint since there are quite a few background threads running.
Raul

On 3/4/2020 9:52 AM, John Taylor wrote:
>
> That's what I was afraid of, not really doable from a practical standpoint since there are quite a few background threads running.

Then just delete files - if you have threads with active components
pointing to the folder you probably don't want to remove it in the first
place.

Raul