IDalCommand

Description

The IDalCommand interface contains properties and methods that are used to work with database using SQL queries.

Properties

	Property name	Brief description
	Connection	The Connection property returns the link on the IDalConnection interface that controls the current database connection.
	CurrentParamsRow	The CurrentParamsRow property returns the index of the current set of parameters.
	InUse	The InUse property returns whether the SQL query is executed on the database at the moment.
	MaxParamsRows	The MaxParamsRows property determines the maximum number of processed sets of parameter values.
	Params	The Params property returns SQL query parameters.
	SQL	The SQL property determines a line (SQL query) that must be executed at the database server.
	Type	The Type property determines a type of executed command.

Methods

	Method name	Brief description
	Close	The Close method closes SQL query without releasing memory reserved for it.
	CreateCursor	The CreateCursor method creates a cursor that enables the user to navigate through data obtained by executing SQL query to database. When a cursor is created, the Execute method is executed automatically.
	DescribeCursor	The DescribeCursor method creates a cursor that contains only data fields.
	Execute	The Execute method executes the command at the database server and returns the number of processed records.
	ExecuteWithoutLast	The ExecuteWithoutLast method executes the command with all sets of parameters except for the last one and returns the number of processed records.
	NextParamsRow	The NextParamsRow method saves the current set of parameters and moves to the next one.
	Parse	The Parse method analyzes a string, detects operators, conditions and parameters. After analyzing the compiler knows which conditions are used in the SQL query, the number of parameters, and so on.
	Prepare	The Prepare method prepares a command for the repeated use at the database server.
	Unprepare	The Unprepare method cancels the effect of the Prepare method. The method is under development.

See also:

Dal Assembly Interfaces