SetBitParameterByName()
- Last UpdatedNov 25, 2015
- 1 minute read
Note: Do not use this method for the Oracle data type Boolean value. Use SetIntParameterByName instead.
Use the SetBitParameterByName() method to configure a bit parameter by the name encoded into the text of a SQL statement using the @ character.
Syntax
result SetBitParameterByName (
string ParameterName,
object ParameterValue,
aaDBParameterDirection ParameterDirection)
Parameters
ParameterName
String identifier used in the SQL statement.
In the following SQL statement the parameter name is boolValue.
"SELECT StateProvinceID
,StateProvinceCode
,CountryRegionCode
,IsOnlyStateProvinceFlag
,Name
,TerritoryID
,rowguid
,ModifiedDate
FROM AdventureWorks.Person.StateProvince
WHERE IsOnlyStateProvinceFlag = @boolValue"
ParameterValue
A discrete value or a valid ArchestrA reference string. For example:
-
0
-
false
-
me.boolValue
Example
SetBitParameterByName ("boolValue", me.boolValue, aaDBParameterDirection.Input)