Icon KeepConnections Property

property KeepConnections: Boolean


Use the KeepConnections property to specify whether or not a temporary TDBISAMDatabase component created in the context of a session maintains a database connection even if there are no active TDBISAMQuery or TDBISAMTable components associated with the TDBISAMDatabase component. If the KeepConnections property is True (the default), the application maintains TDBISAMDatabase connections until the application exits or calls the DropConnections method. For remote sessions, the KeepConnections property should remain True to reduce network traffic and avoid constantly opening and closing databases.

When the KeepConnections property is False, an application disconnects from a database when all TDBISAMQuery and TDBISAMTable components associated with a TDBISAMDatabase component are closed. Dropping a connection releases system resources allocated to the connection, but if a dataset is later reopened that uses the same database, the connection must be reestablished and initialized.

Information The duration of a connection for a persistent, not temporary, TDBISAMDatabase component is determined by the TDBISAMDatabase component's KeepConnection property instead of the session's KeepConnections property.