PickDPCommand Component

Represents a Pick statement or stored procedure to execute against a Pick Server database. This class cannot be inherited.

NOTE: When executing a stored procedure, the order in which the parameters are added to the PickDPCommand is the order in which they are passed to the calling program.

Public Constructors

Public Methods

Cancel (Inherited from IDbCommand)	Attempts to cancel the execution of a System.Data.PickDP.PickDPCommand.
Dispose	For internal use only.
CreateParameter (Inherited from IDbCommand)	Creates a new instance of a System.Data.PickDP.PickDPParameter object. This method does not associate the created parameter with the command. After creation, the parameter must be associated with the command by using the either the PickDPParameterCollection.Add or PickDPParameterCollection.AddRange method.
ExecuteNonQuery	Executes a D3 statement against the Connection object of a .NET Framework data provider, and returns the number of rows affected by the UPDATE, INSERT, or DELETE commands. All other commands return -1.
ExecuteReader	Executes the System.Data.PickDP.PickDPCommand.CommandText against the System.Data.PickDP.PickDPCommand.Connection, and builds a System.Data.PickDP.PickDPDataReader using one of the System.Data.CommandBehavior values (when specified).
ExecuteScalar	Executes the query, and returns the first column of the first row in the resultset returned by the query. Extra columns or rows are ignored.
Prepare	Creates a prepared (or compiled) version of the command on the data source. If the TableDirect CommandType is used with the ExecuteReader method, an InvalidOperationException is thrown if the Prepare method is not called before the ExecuteReader.

Public Properties

Name	Type	Description
ColumnNames	String	Space delimited list of columns to return when the command is executed. For example: “ORDERID EMPLOYEEID"
CommandText	String	Contains the original command text prior to parameter substitution.
CommandTextOriginal	String	Gets or sets the original text command to run against the data source.
CommandTimeout	Integer	Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
CommandType	System.Data.CommandType	Indicates or specifies how the System.Data.PickDP.PickDPCommand.CommandText property is interpreted. Can Be: StoredProcedure TableDirect Text See CommandText for more information on these command types.
Connection	System.Data.PickDP.PickDPCommand.Connection	Gets or sets the System.Data.PickDP.PickDPCommand.Connection used by this instance of the System.Data.PickDP.PickDPCommand.
Criteria	String	Selection criteria section of the AQL statement. For example: "WITH ORDERID > '95'"
DesignTimeVisible	Boolean	Gets or sets a value indicating whether the command object should be visible in a Windows Forms Designer control.
LockType	System.Data.PickDP.PickDPSupport.PickDPLockType	Gets or sets the System.Data.PickDP.PickDPSupport.PickDPLockType.
Parameters	System.Data.PickDP.PickDPParameterCollection	Gets the System.Data.PickDP.PickDPParameterCollection.
QueryName	String	Gets or sets the queryname.
Sort	String	AQL sort order. For example: “BY-DSND ORDERID”
Table	RDTA.PickDP.Connector.connTable	Gets the table from the RDTA.PickDP.Connector.connTable object.
TableName	String	Gets the tablename.
Transaction	System.Data.PickDP.PickDPTransaction	Gets or sets the transaction within which the Command object of a .NET Framework data provider executes.
UpdatedRowSource	System.Data.UpdateRowSource	Gets or sets how command results are applied to the System.Data.DataRow when used by the System.Data.PickDP.PickDPDataAdapter.Update(System.Data.DataSet) method of a System.Data.PickDP.PickDPDataAdapter.