UnionController (Property)

Applies To:

AppendQueriesSection object

Description:

Returns or sets the value of the Append Query union operator. This operator determines how rows are retrieved when you use the Append Query Option feature.

UnionController uses the BqUnionController constant group, which consists of the bqUnion and bqUnionAll constants value. Use bqUnion to retrieve all distinct rows selected by either query without duplicates. Use bqUnionAll to programmatically retrieve all rows selected by either query, including duplicate rows.

Action:

Read-write

Constants:

The BqUnionController constant consists of these values:

This is the UnionController Constant Definition:

typedef enum BqUnionController
{	
	bqUnion = 1,
	bqUnionAll,
} BqUnionController;

Example:

This example shows how to append a query using the Union operator.

ActiveDocument.Sections["Query"].AppendQueries.Add()
ActiveDocument.Sections["Query"].AppendQueries[1].UnionController=bqUnion