CloseCachedTables

Advantage TDataset Descendant

Close all cached tables on the connection.

Syntax

procedure CloseCachedTables;

Description

CloseCachedTables can be used to close all cached tables on a given connection. All cached closed tables on the client will be closed, as well as all cache closed tables on the server that might have been used when executing SQL statements.

This method can be useful if you know another application (or some other instance of the same application) will require exclusive access to a table that has been used by the existing application, or if you want tables used by some server-side functionality (like an extended procedure, or a trigger) to be available for exclusive use by the client at some later time.

Note If using this function you must still call TAdsQuery.AdsCloseSQLStatement to force queries to completely close all files they have used. If you wish to close all tables used by all queries you can use the TAdsConnection.DataSets property to iterate through all queries and call AdsCloseSQLStatement on each one before calling CloseCachedTables.