TSQLConnection Methods

The methods of the TSQLConnection class are listed here.

	Name	Description
	CheckConnection	This is CheckConnection, a member of class TSQLConnection.
	CheckDisconnect	This is CheckDisconnect, a member of class TSQLConnection.
	ConnectionOptions	This is ConnectionOptions, a member of class TSQLConnection.
	DoConnect	Provides the interface for a method that opens a connection.
	DoDisconnect	Provides the interface for a method that terminates the connection.
	GetConnected	Returns the value of the Connected property.
	GetDataSet	Returns a dataset, given its index in the DataSets property array.
	Loaded	Initializes the connection component after all objects in the form or data module have been loaded.
	Notification	Forwards notification messages to all owned components.
	OpenSchema	This is the overview for the OpenSchema method overload.
	RegisterClient	Registers an object that uses the connection component.
	SQLError	This is SQLError, a member of class TSQLConnection.
	UnRegisterClient	Removes a registered client so that it is no longer associated with the connection component.

Public Methods

	Name	Description
	AddConnectNotification	This is AddConnectNotification, a member of class TSQLConnection.
	BeginTransaction	This is the overview for the BeginTransaction method overload.
	CloneConnection	Returns a copy of the SQL connection object.
	CloseDataSets	Closes all datasets associated with the SQL connection object component without disconnecting from the database.
	Commit	Commits an open transaction.
	CommitFreeAndNil	Commits an open transaction.
	Execute	Executes an SQL command on the server.
	ExecuteDirect	Executes an SQL command that does not include parameters.
	GetCommandTypes	This is GetCommandTypes, a member of class TSQLConnection.
	GetDefaultSchemaName	Returns the default schema name of the current object.
	GetFieldNames	This is the overview for the GetFieldNames method overload.
	GetIndexNames	This is the overview for the GetIndexNames method overload.
	GetLoginUsername	Returns the username that is logged in on the current connection.
	GetPackageNames	This is the overview for the GetPackageNames method overload.
	GetProcedureNames	This is the overview for the GetProcedureNames method overload.
	GetProcedureParams	This is the overview for the GetProcedureParams method overload.
	GetSchemaNames	This is the overview for the GetSchemaNames method overload.
	GetServerMethodNames	This is GetServerMethodNames, a member of class TSQLConnection.
	GetTableNames	This is the overview for the GetTableNames method overload.
	HasTransaction	This is HasTransaction, a member of class TSQLConnection.
	LoadParamsFromIniFile	Sets the DriverName and Params properties to the values associated with the ConnectionName property.
	RemoveConnectNotification	This is RemoveConnectNotification, a member of class TSQLConnection.
	Rollback	Cancels all updates, insertions, and deletions for a specified transaction and ends the transaction.
	RollbackFreeAndNil	Cancels all updates, insertions, and deletions for a specified transaction and ends the transaction.
	RollbackIncompleteFreeAndNil	Cancels all updates, insertions, and deletions for a specified transaction and ends the transaction.
	SetTraceEvent	Associates the SQL connection with a callback function that executes for every SQL command passed to or from the server.
	StartTransaction	Initiates a new transaction in the associated database.

What do you think about this topic? Send feedback!