TADCommand Members

The following tables list the members exposed by TADCommand.

Event	Description
AfterClose	The event fires after command is closed.
AfterExecute	The event fires after command is executed.
AfterFetch	The event fires after fetching from command cursor.
AfterOpen	The event fires after command is opened.
AfterPrepare	The event fires after command is prepared.
AfterUnprepare	The event fires after command is unprepared.
BeforeClose	The event fires before command will be closed.
BeforeExecute	The event fires before command will be executed.
BeforeFetch	The event fires before fetching from command cursor.
BeforeOpen	The event fires before command will be opened.
BeforePrepare	The event fires before command will be prepared.
BeforeUnprepare	The event fires before command will be unprepared.
OnCommandChanged	The event fires after CommandText is changed.
OnError	The event fires when an error happens, while command is communicating with DBMS.

TADCommand Class

Method	Description
AbortJob	Use the AbortJob method to abort current command operation.
AcquireConnection	Acquires reference to the actual connection object.
Close	Closes command current cursor.
CloseAll	Closes all command cursors.
Define	Defines DatS manager for command multiple result sets.
Define	Define DatS table structure for command's current cursor.
Disconnect	Use Disconnect method to release DBMS resources, used by this command.
Execute	Executes SQL command.
Execute	Executes SQL command.
Execute	Executes SQL command.
Execute	Executes SQL command.
Fetch	Fetches rows from current command cursor.
FillParams	Fills the Params collection.
FindMacro	Returns macro by its name.
FindParam	Returns parameter by its name.
GetConnection	Returns the connection object.
MacroByName	Returns macro by its name.
NextRecordSet	Go to the next cursor, returned by the SQL command.
Open	Executes SQL command, returning cursor.
OpenOrExecute	Execute SQL command, optionally returning cursor.
ParamByName	Returns parameter by its name.
Prepare	Prepares SQL command for execution.
ReleaseConnection	Releases reference to the actual connection object.
Unprepare	Releases SQL command resources.

Property	Description
Active	Gets or sets command active status.
ActiveStoredUsage	Controls how to use Active property value saved to DFM.
BaseObjectName	Identifies base object name for some of command kinds.
BindedBy	Determines how command is connected to connection object.
CatalogName	Identifies catalog name for some command kinds.
CommandIntf	Returns IADPhysCommand interface.
CommandKind	Identifies the command kind.
CommandText	The SQL command text to execute.
Connection	Specifies the connection object.
ConnectionName	Specifies connection name.
DataSet	Reference to dataset object owning this command.
FetchOptions	The set of options to control rows fetching.
FixedCommandKind	True, if the CommandKind property value is set explicitly.
FormatOptions	The set of options to control data representation.
Macros	The collection of macro substitution variables.
Overload	Oracle stored procedure overload index.
ParamBindMode	Determines the order in which a component’s parameters are assigned to the parameter list for SQL command on the DBMS.
Params	The collection of parameters for a SQL command.
Prepared	Gets or sets command prepare for execution status.
ResourceOptions	The set of options to control resources usage.
RowsAffected	Returns the number of rows operated upon by the latest query execution.
SchemaName	Identifies schema name for some of command kinds.
SQLText	The SQL command text as it will be sent to the DBMS.
State	Returns the current state of the command object.
Transaction	Specifies a transaction object.
UpdateOptions	The set of options to control updates posting.
Values	Provides access to the values for all parameters for the command.

Events, TADCommand Class, Legend, Methods, Properties