[AccessD] QyeryDef.Type dbQCompound

Gustav Brock gustav at cactus.dk
Sun Jun 23 09:59:36 CDT 2013


Hi John

Yes, I'm familiar with the word compound.

My question is how to create or where to meet an Access QyeryDef with property Type of dbQCompound.

/gustav

>>> djkr at msn.com 23-06-13 15:41 >>>
Hi Gustav

Well, a UNION query is compound in that it comprises two or more elements (queries), however complex or simple each is.
That's what 'compound' means in English.  But equally UNION (and INTERSECT and EXCEPT) queries can be called Set
Operation queries, because they can be considered as doing set operations.  Set Theory.

But I feel that you're trying to figure out what kinds of queries Access classifies as dbQCompound (and possibly dbQSetOperation).  Now we're trying to second guess MS logic - the answer could be none!

John


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 23 June 2013 13:35
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] QyeryDef.Type dbQCompound


Hi John

I think this is just a common way of talking about a query that it is a little more than a straight select/update/append
query. My feeling is, that an Access compound query is something quite special with its own icon.



/gustav 

>>> djkr at msn.com 23-06-13 13:55 >>>
Hi Gustav

Here's the best I can do (from http://www.informit.com/ and Sams Teach Yourself SQL in 24 Hours):

"The compound query operators vary among database vendors. The ANSI standard includes the UNION, UNION ALL, EXCEPT, and
INTERSECT operators".

Which does seem to make sense.  After all a compound query is not merely a complex one, nor perhaps a query containing a
subquery.  The SAMS book also says "Compound queries enable you to combine the results of more than one query to return
a single set of data."  Exactly.

Whether this agrees with Access's use of the term, however, is another matter entirely!

John


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 23 June 2013 08:52
To: accessd at databaseadvisors.com
Subject: [AccessD] QyeryDef.Type dbQCompound


Hi all

Could anyone please tell me what a compound query in Access is?

Of course, I've binged/googled and searched the on-line "help" but didn't find a single clue.

/gustav



More information about the AccessD mailing list