SetDateTimeParameterByIndex()
- Last UpdatedOct 13, 2022
- 1 minute read
Use the SetDateTimeParameterByIndex() method to configure a DateTime parameter as encoded into the text of an OLEDB SQL statement.
Syntax
result SetDateTimeParameterByIndex (
int Index,
object ParameterValue,
aaDBParameterDirection Parameterdirection)
Parameters
Index
The sequential index of the parameter as used in the SQL statement. For example:
In the following SQL statement the parameter corresponds to the question mark (?) character:
"INSERT INTO Purchasing.PurchaseOrderDetail
(PurchaseOrderID
,DueDate
,OrderQty
,ProductID
,UnitPrice
,ReceivedQty
,RejectedQty
,ModifiedDate)
VALUES
(4,'2008-01-28',4,4,4,12.89,12.56,?)"
ParameterValue
DateTime, string value, or a valid ArchestrA reference string.
For example:
-
'2004-03-11 10:17:21.587'
-
me.dtValue
ParameterDirection
For possible values, see aaDBParameterDirection.
Example
SetDateTimeParameterByIndex (1, me.dtValue, aaDBParameterDirection.Input)