SetDecimalParameterByName()

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

Syntax

result SetDecimalParameterByName (
string ParameterName,
object ParameterValue,
aaDBParameterDirection ParameterDirection,
short Precision,
short Scale)

Parameters

ParameterName

The string identifier used in the SQL statement.

In the following SQL statement the name of the parameter is "RejectedQuantity".

"INSERT INTO Purchasing.PurchaseOrderDetail

(PurchaseOrderID

,DueDate

,OrderQty

,ProductID

,UnitPrice

,ReceivedQty

,RejectedQty

,ModifiedDate)

VALUES

(4,'2008-01-28',4,4,4,12.89,@RejectedQuantity,
'2008-01-28') "

ParameterValue

This parameter supports float, double or string values.

You can also specify a valid ArchestrA reference string. For example:

• 123.333

• "123.333333333333333333"

• me.Quantity

ParameterDirection

For possible values, see aaDBParameterDirection.

Precision

A number that indicates the total number of digits.

Scale

A number that indicates the number of digits to the right of the decimal point.

Example

SetDecimalParameterByName ("RejectedQuantity", me.Quantity,aaDBParameterDirection.Input, 8, 2)