SetLongParameterByName()
- Last UpdatedOct 13, 2022
- 1 minute read
Use the SetLongParameterByName() method to configure a long parameter by the name encoded into the text of a SQL statement using the @ character.
Syntax
result SetLongParameterByName (
string ParameterName,
object ParameterValue,
aaDBParameterDirection ParameterDirection)
Parameters
ParameterName
The string identifier that is used in the SQL statement.
In the following SQL statement the name of the output parameter is "ProdID"
"SELECT ProductID, SUM(WorkOrderID)
AS OrderCnt
FROM Production.WorkOrder
WHERE ProductID = @ProdID
GROUP BY ProductID"
ParameterValue
An integer value or a valid ArchestrA reference string. For example:
-
10
-
me.ProductID
-
Null - Output
ParameterDirection
For possible values, see aaDBParameterDirection.
Example
SetLongParameterByName ("ProdID",me.ProductID,aaDBParameterDirection.Output)