Subject Re: BLOB File not found
From Mervyn Bick <invalid@invalid.invalid>
Date Mon, 24 May 2021 09:21:38 +0200
Newsgroups dbase.getting-started

On 2021/05/23 17:12, Leif wrote:

> Thanks for all the info,
> The software is old and made in the past with dBase Plus, however it's still working fine so no reason to change anything. I have to run it under dBase Plus though as it does not work properly with later dBase versions. Looking for an answer to this new problem I have tried many things. Now I got it to work OK again, what did I do ? I found following files in the program directory which I deleted and the it worked ok again.
> _QSQL000.DBF
> _QSQL305.DBF
> _QSQL317.DBF
> _QSQL317.DBT
> _QSQL641.DBF
> _QSQL641.DBT
> _QSQL645.DBF
> _QSQL645.DBT

These are temporary files created by the BDE under certain circumstances
such as when one uses an ORDER BY clause in a query.  dBASE should
delete them automatically when the application closes but sometimes they
get left behind.

dBASE can only create 1000 _QSQLnnn.dbf files.  Once that limit is
reached it causes errors.  You can safely delete these files.

Mervyn.