SetBitParameterByIndex()

Use the SetBitParameterByIndex() method to configure a bit parameter as encoded into the text of an OLEDB SQL statement.

Syntax

result SetBitParameterByIndex (
int Index,
object ParameterValue,
aaDBParameterDirection ParameterDirection)

Parameters

Index

The sequential index of the parameter as used in the SQL statement.

In the following SQL statement, the parameter corresponds to the question mark (?) character:

"SELECT StateProvinceID

,StateProvinceCode
,CountryRegionCode
,IsOnlyStateProvinceFlag
,Name
,TerritoryID
,rowguid
,ModifiedDate

FROM AdventureWorks.Person.StateProvince

WHERE IsOnlyStateProvinceFlag = ?"

ParameterValue

A discrete value or a valid ArchestrA reference string. For example:

• 0.

• false.

• me.boolValue.

• ParameterDirection. For possible values, see aaDBParameterDirection.

Example

SetBitParameterByIndex (0, me.boolValue, aaDBParameterDirection.Input)