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
	BeginTransaction	Initiates a new transaction in the associated database.
	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.
	CommitAndFree	This is CommitAndFree, a member of class TSQLConnection.
	Execute	Executes an SQL command on the server.
	ExecuteDirect	Executes an SQL command that does not include parameters.
	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	Populates a string list with the names of all packages defined on the server.
	GetProcedureNames	This is the overview for the GetProcedureNames method overload.
	GetProcedureParams	This is the overview for the GetProcedureParams method overload.
	GetSchemaNames	Returns the schema names for all objects in the given data source.
	GetTableNames	This is the overview for the GetTableNames method overload.
	LoadParamsFromIniFile	Sets the DriverName and Params properties to the values associated with the ConnectionName property.
	Rollback	Cancels all updates, insertions, and deletions for a specified transaction and ends the transaction.
	RollbackAndFree	This is RollbackAndFree, a member of class TSQLConnection.
	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!