2.5.199 PBT
The PBT structure specifies information about a parameter in a query that retrieves external data for a PivotTable or a query table. The values in this structure provide additional information about the related ParamQry record as specified by the rgPbt field in the DBQueryExt record that contains this structure.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pbt |
A |
B |
reserved |
pbt (3 bits): An unsigned integer that specifies the location of the parameter value. MUST be the same as the pbt field in the related ParamQry record as specified by the rgPbt field in the DBQueryExt record that contains this structure. MUST be a value from the following table:
-
Value
Meaning
0x0
The user is prompted for the value of the parameter.
0x1
The parameter value is specified in the query.
0x2
The parameter value is specified in a cell.
A - fAutoRefresh (1 bit): A bit that specifies whether the query refreshes when the parameter value changes. If pbt is not equal to 0x2 then this bit MUST be zero, and MUST be ignored.
B - fNeedRefresh (1 bit): A bit that specifies that the parameter value changed and the query was not refreshed. MUST be 0 if pbt is not equal to 0x2.
reserved (11 bits): MUST be zero, and MUST be ignored.