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.


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

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.