DJK (John) Robinson
djkr at msn.com
Sun Jun 23 10:45:28 CDT 2013
Hi Gustav Do you think it may not be possible to encounter this value? That MS have over-specified the QueryDefTypeEnum list? For instance, I know four types of Action Queries in Access: Append, Delete, MakeTable and Update, each of which appears in the list. So what kind of query gives you dbQAction? Some other kind of Action Query? Do you know? As an aside, I note that the MSDN lists for A07 and A13 describe dbQSetOperation as "Set operation", where the list for A10 lists it as "Union". Both valid, given that Access doesn't implement either INTERSECT or EXCEPT, at least AFAIK. Good luck with the quest, but there may not be a pot of gold ... John -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: 23 June 2013 16:00 To: accessd at databaseadvisors.com Subject: Re: [AccessD] QyeryDef.Type dbQCompound 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com