2.5.197 PARAMQRY_Fixed

 PARAMQRY_Fixed structure contains information about SQL query parameters.

0	1	2	3	4	5	6	7	8	9	1 0	1	2	3	4	5	6	7	8	9	2 0	1	2	3	4	5	6	7	8	9	3 0	1
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	SXString
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.