2.5.197 PARAMQRY_Fixed
PARAMQRY_Fixed structure contains information about SQL query parameters.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
wTypeSql |
pbt |
A |
B |
unused2 |
|||||||||||||||||||||||||||
|
grbit |
fVal |
||||||||||||||||||||||||||||||
wTypeSql (2 bytes): An ODBCType structure that specifies the SQL data type.
pbt (2 bits): An unsigned integer that specifies the parameter type. MUST be a value from the following table:
-
Value
Meaning
0
Prompt. User is prompted for the value of the parameter.
1
Value. The parameter value is specified in the query.
2
Reference. The parameter value is specified in a cell.
A - unused1 (1 bit): Undefined and MUST be ignored.
B - fNonDefaultName (1 bit): A bit that specifies whether to use the default prompt if pbt is equal to 0. MUST be a value from the following table:
-
Value
Meaning
0
User entered prompt is used
1
Application’s default prompt is used
unused2 (12 bits): Undefined and MUST be ignored.
grbit (2 bytes): An unsigned integer that specifies the type of data that follows this structure as specified in the following table or the presence of a Boolean value in fVal if pbt equals 1. MUST be a value from the following table if pbt equals 1:
-
Value
Meaning
0x001
Xnum (section 2.5.342)
0x002
0x004
Boolean (section 2.5.14) value in fVal.
0x800
4 byte unsigned integer
fVal (2 bytes): A Boolean that specifies value such that if pbt equals 1 and grbit equals 4. MUST be equal to 0 or 1 if pbt equals 1 and grbit equals 4. MUST be ignored if pbt is not equal to 1 or grbit is not equal to 4.