SetDoubleParameterByName()

Use the SetDoubleParameterByName() method to configure a double parameter by the name encoded into the text of a SQL statement using the @ character.

Syntax

result SetDoubleParameterByName (
string ParameterName,
object ParameterValue,
aaDBParameterDirection ParameterDirection)

Parameters

ParameterName

The string identifier used in the SQL statement.

In the following SQL statement the output parameter name is "AvgReject"

"SELECT @AvgReject = 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 on.

Example

SetDoubleParameterByName ("AvgReject",null,aaDBParameterDirection.Output)