SetLongParameterByIndex()

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

Syntax

result SetLongParameterByIndex (
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 ProductID, SUM(WorkOrderID) AS OrderCnt

FROM Production.WorkOrder

WHERE ProductID = ?

GROUP BY ProductID"

ParameterValue

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

• 123.333

• me.ProductID

ParameterDirection

For possible values, see aaDBParameterDirection.

Example

SetLongParameterByIndex (1, me.ProductID, aaDBParameterDirection.Output)