SetIntParameterByIndex()

Use the SetIntParameterByIndex() method to configure a integer parameter as encoded into the text of an OLEDB SQL statement.

Syntax

result SetIntParameterByIndex (
int Index,
object ParameterValue,
aaDBParameterDirection ParameterDirection)

Parameters

Index

The sequential index of the parameter as used in the SQL statement.

In the following SQL statement the output parameter corresponds to the question mark (?) character.:

"SELECT ? = Avg(RejectedQty)

FROM Purchasing.PurchaseOrderDetail "

ParameterValue

A double-precision floating number or a valid ArchestrA reference string. For example:

• 123.333

• me.Limit

ParameterDirection

For possible values, see aaDBParameterDirection.

Example

SetIntParameterByIndex (1, null, aaDBParameterDirection.Output)