Data.SqlExpr.TSQLConnection.KeepConnection
Delphi
property KeepConnection: Boolean read FKeepConnection write SetKeepConnection default True;
C++
__property bool KeepConnection = {read=FKeepConnection, write=SetKeepConnection, default=1};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TSQLConnection |
Description
Specifies whether the connection stays active when no datasets are open.
Use KeepConnection to specify whether TSQLConnection maintains an open database connection even if no associated dataset components are currently active. When KeepConnection is true (the default) the connection is maintained. For connections to remote database servers, or in applications that frequently open and close datasets, set KeepConnection to true to reduce network traffic, speed up applications, and avoid logging in to the server each time the connection is reestablished.
When KeepConnection is false a connection is dropped when there are no open datasets. Dropping a connection releases system resources allocated to the connection, but if a dataset is later opened that uses the database, the connection must be reestablished and initialized.