TSQLConnection class

In unit SQLDB

An abstract class representing a connection to a SQL Database.

Declaration

pascal

TSQLConnection = class(TDatabase)

Inheritance

Descends from it: TIBConnection TMSSQLConnection TSQLConnector

Description

TSQLConnection is an abstract class for making a connection to a SQL Database. This class will never be instantiated directly, for each database type a descendent class specific for this database type must be created.

Most of common properties to SQL databases are implemented in this class.

Properties

`Statements`	protected
`Port`	protected	Port the SQL engine is listening on.
`CodePage`	protected
`ConnOptions`	public	The set of Connection options being used in the Connection.
`Handle`	public	Low level handle used by the connection.
`FieldNameQuoteChars`	public	Characters used to quote field names.
`Password`	published	Password used when authenticating on the database server.
`Transaction`	published	Default transaction to be used for this connection.
`UserName`	published	The username for authentication on the database server.
`CharSet`	published	The character set to be used in this database.
`HostName`	published	The name of the host computer where the database resides.
`LogEvents`	published	Filter for events to log.
`Options`	published	Options to observe for this connection.
`Role`	published	Role in which the user is connecting to the database.
`Connected`	published	Is a connection to the server active or not.
`DatabaseName`	published	The name of the database to which connection is required.
`KeepConnection`	published	Attempt to keep the connection open once it is established.
`LoginPrompt`	published	Should SQLDB prompt for user credentials when a connection is activated.
`Params`	published	Extra connection parameters.

Methods

`AddFieldToUpdateWherePart`	protected
`ConstructInsertSQL`	protected
`ConstructUpdateSQL`	protected
`ConstructDeleteSQL`	protected
`ConstructRefreshSQL`	protected
`CreateCustomQuery`	protected
`InitialiseUpdateStatement`	protected
`ApplyFieldUpdate`	protected
`ApplyRecUpdate`	protected
`RefreshLastInsertID`	protected
`GetDBInfo`	protected
`PortParamName`	protected
`GetConnectionCharSet`	protected
`SetTransaction`	protected
`DoConnect`	protected
`DoInternalConnect`	protected
`DoInternalDisconnect`	protected
`GetAsString`	protected
`GetAsSQLText`	protected
`GetHandle`	protected
`LogEvent`	protected
`LogParams`	protected
`Log`	protected
`RegisterStatement`	protected
`UnRegisterStatement`	protected
`UnPrepareStatements`	protected
`AllocateCursorHandle`	protected
`DeAllocateCursorHandle`	protected
`StrToStatementType`	protected
`PrepareStatement`	protected
`UnPrepareStatement`	protected
`Execute`	protected
`RowsAffected`	protected
`Fetch`	protected
`AddFieldDefs`	protected
`AddFieldDef`	protected
`LoadField`	protected
`LoadBlobIntoBuffer`	protected
`FreeFldBuffers`	protected
`AllocateTransactionHandle`	protected
`GetTransactionHandle`	protected
`Commit`	protected
`RollBack`	protected
`StartImplicitTransaction`	protected
`StartDBTransaction`	protected
`CommitRetaining`	protected
`RollBackRetaining`	protected
`UpdateIndexDefs`	protected
`GetSchemaInfoSQL`	protected
`GetNextValueSQL`	protected
`MaybeConnect`	protected
`Create`	public	Create a new instance of TSQLConnection.
`Destroy`	public	Destroys the instance of the connection.
`StartTransaction`	public	Start the Transaction associated with this Connection.
`EndTransaction`	public	End the Transaction associated with this connection.
`ExecuteDirect`	public	Execute a piece of SQL code directly, using a Transaction if specified.
`GetObjectNames`	public	Return a collection of object names for a given type of object.
`HasTable`	public
`GetTableNames`	public	Get a list of the tables in the specified database.
`GetProcedureNames`	public	Gets a list of Stored Procedures in the Database.
`GetFieldNames`	public	Gets a list of the field names in the specified table.
`GetSchemaNames`	public	Get database schema names.
`GetSequenceNames`	public	Return a list of sequence names.
`GetConnectionInfo`	public	Return some information about the connection.
`GetStatementInfo`	public	Get statement information.
`CreateDB`	public	Create a new Database on the server.
`DropDB`	public	Procedure to drop or remove a Database.
`GetNextValue`	public	Get next value for a sequence.