PARAMQRY: Query Parameters (DCh)

This record contains query data.

Note

PARAMQRY has the same record number as SXEXT. This has no adverse ramifications in a BIFF file because PARAMQRY always occurs in conjunction with an SXEXT record.

Record Data — BIFF8

Offset	Name	Size	Contents

4	wTypeSql	2	Used for ODBC queries; the parameter SQL type
6	grbit	2	Option flags; see following table
8	fVal	2	A true/false value if pbt = 2 and the parameter is a Boolean
10	rgb	var	(See text)

The grbit field contains the option flags listed in the following table.

Bits	Mask	Name	Contents

1 – 0	0003h	pbt	Parameter binding type: = 0 Prompt type (for example, "Please enter a date") = 1 Fixed value type (for example, 10, "MSFT", 01/06/97, and so on) = 2 Reference type (for example, "=Sheet2!$A$5")
2	0004h	fAuto	= 1 for automatic parameters
3	0008h	fNonDefaultName	= 0 then program prompts for the name
15 – 4	FFF0h	Reserved	Reserved; must be 0 (zero)

The rgb field can contain several different data types. If pbt = 0, then rgb contains the prompt string as a unicode string; for more information see "Unicode Strings in BIFF8" on page 264.

If pbt = 1 (a value field), then rgb contains one of the following:

An 8-byte IEEE number for dates and decimal numbers
A 4-byte long integer
A variable-length unicode string for bound string values
No data if the value is Boolean; the value is then stored in fVal

If pbt = 2, then the rgb contains a parsed expression for the reference.