skip to main content
Developing ADO.NET Applications : Microsoft .NET Public Objects/Interfaces Supported : OpenAccessCommand Object
 

OpenAccessCommand Object

In addition to the public properties of the Command object, the OpenAccessCommand object supports the properties described in the following table. The table includes the generic public properties of the Command object when provider-specific information supplements the standard descriptions.
For information about other properties and methods supported, refer to the .NET Client’s online help and the Microsoft .NET Framework SDK documentation.
 
Table 32: Properties of the OpenAccessCommand Object  
Property
Description
ArrayBindCount
Specifies the number of rows of parameters that will be used. The application must set this property before executing a command that uses parameter array binding. The count must equal the length of each of the arrays that is set for each parameter value.
When set to 0 (the initial default), the application does not use parameter array binding.
ArrayBindStatus
Enables the application to inspect the per row status after executing a command that uses parameter array binding. The property's type is an array of OpenAccessRowStatus.
Parameter array binding is performed as a single atomic operation. This means that if the operation succeeds, every entry will be set to OK; if the operation fails, none of the entries will be set to OK. The OpenAccessRowStatus enumeration has the following possible values:
• OK. The operation succeeded. All entries are marked as OK.
• Failed. The operation failed. The .NET Client assigns this value to all status entries except for the row that caused the failure.
• SchemaViolation. When an operation fails, the .NET Client assigns this value to the row that caused the failure.
RowSetSize
Limits the number of rows returned by any query executed on this Command object to the value specified at execution time. The data type for the Read-Write property is unsigned long.
Valid values are 0 to 2147483647. When set to 0, the .NET Client does not limit the number of rows returned.
The initial default is 0.