SetCharParameterByIndex()

Use the SetCharParameterByIndex() method to configure a character string parameter as encoded into the text of an OLEDB SQL statement.

Syntax

result SetCharParameterByIndex (

int Index,

string ParameterValue,

aaDBParameterDirection ParameterDirection,

int Length)

Parameters

Index

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

In the following SQL statement the input parameter corresponds to the question mark (?) character.

"SELECT * FROM Person.Contact WHERE (LastName > ?)"

ParameterValue

A string constant or valid ArchestrA reference string. For example:

• "Smith"

• me.LastName

• null - Output and ReturnValue parameters

ParameterDirection

For possible values, see aaDBParameterDirection.

Length

The maximum length of the parameter.

If the length of the parameterValue is greater, the parameterValue is truncated to the specified length.

Example

SetCharParameterByIndex (0, "Smith",aaDBParameterDirection.Input, 50)