SetFloatParameterByName()

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

Syntax

result SetFloatParameterByName (
string ParameterName,
object ParameterValue,
aaDBParameterDirection ParameterDirection

Parameters

ParameterName

String identifier used in the SQL statement.

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

"SELECT @AvgReject = Avg(RejectedQty)

FROM Purchasing.PurchaseOrderDetail "

ParameterValue

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

• 123.333

• me.Limit

ParameterDirection

For possible values, see aaDBParameterDirection.

Example

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