[AccessD] QyeryDef.Type dbQCompound

Arthur Fuller fuller.artful at gmail.com
Sun Jun 23 10:42:15 CDT 2013


I found this on the MSDN site:

Name

Value

Description

dbQAction

240

Action query

dbQAppend

64

Append query

dbQCompound

160

Compound query

dbQCrosstab

16

Crosstab query

dbQDDL

96

Data-definition language (DDL) query

dbQDelete

32

Delete query

dbQMakeTable

80

Make-table query

dbQProcedure

224

SQL procedure that executes a stored procedure

dbQSelect

0

Select query

dbQSetOperation

128

Set operation query

dbQSPTBulk

144

Bulk operation query

dbQSQLPassThrough

112

SQL pass-through query

dbQUpdate

48

Update query

I Googled compound query and this example came up:

SELECT EMP_ID FROM EMPLOYEE_TBL
UNION
SELECT EMP_ID FROM EMPLOYEE_PAY_TBL;

The ANSI standard for compound queries includes UNION, UNION ALL, EXCEPT
and INTERSECT. Support for these keywords depends upon the back end.

Arthur


More information about the AccessD mailing list