Hi!


Is there a way to automatically delete the temporary tables (numerical tables in db dir)
created by queries?

If not, what is the easiest way to delete those which are not used.

Annar wrote:
> Hi!
>
>
> Is there a way to automatically delete the temporary tables
> (numerical tables in db dir) created by queries?

They will be deleted when the query objects that use these tables are
closed.

> If not, what is the easiest way to delete those which are not used.

Close the queries. If some files are left, then something ugly happens, like
a crash. Then simply delete the files.

Ralf

Annar,

<< Is there a way to automatically delete the temporary tables (numerical
tables in db dir) created by queries? >>

The first thing you should do is make sure that your
TDBISAMSession.PrivateDir property is set to a temporary directory on the
local drive:

http://www.elevatesoft.com/dbisam4d5_tdbisamsession_privatedir.htm

That will keep those tables out of your database directory, and then you can
simply delete all of the files in the temporary directory as necessary.
Also, keep in mind that these files are only left around when your
application improperly terminates.  Under normal circumstances, DBISAM will
delete them automatically when it no longer needs them.

--
Tim Young
Elevate Software
www.elevatesoft.com