Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

QyeryDef.Type dbQCompound

Posted on 2013-06-23
9
Medium Priority
?
415 Views
Last Modified: 2013-06-29
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

PS: It is not just a select query with more than one criteria.
0
Comment
Question by:Gustav Brock
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 14

Assisted Solution

by:Bill Ross
Bill Ross earned 600 total points
ID: 39269197
Hi,

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

This is not a common term and there is no query in MS Access sor SQL that is designated as compound.

It could mean a UNION query where 2 or more select queries are combined.

Regards,

Bill
0
 
LVL 27

Assisted Solution

by:MacroShadow
MacroShadow earned 300 total points
ID: 39269210
From babylon.com:
compound query

A query that is composed of at least one action query (a query that copies or changes data) and at least one select query (a query that returns a Recordset without changing data). In DAO, a compound query is created by putting two or more SQL statements (separated by semicolons) in the SQL property of a QueryDef object.
0
 
LVL 51

Author Comment

by:Gustav Brock
ID: 39269417
Thanks, I'm familiar with the word compound and what it could cover in this context.

However, my question is how to create or where to meet an Access QyeryDef with property Type of dbQCompound:

QueryDefTypeEnum Enumeration (DAO)

I've never seen such neither read about it.

/gustav
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 51

Author Comment

by:Gustav Brock
ID: 39269554
I found an Access 97 help file and it also states something like:
A query that is composed of at least one action query (a query that copies or changes data) and at least one select query (a query that returns a Recordset without changing data). In DAO, a compound query is created by putting two or more SQL statements (separated by semicolons) in the SQL property of a QueryDef object.
However, if I try that, an error is raised that characters are found after the semicolon ...

So, does an example exist?

/gustav
0
 
LVL 51

Accepted Solution

by:
Gustav Brock earned 0 total points
ID: 39269581
I found this:

http://office.microsoft.com/en-in/access-help/HV080753770.aspx

which could indicate that it is (was) a specific situation for an ODBC Direct workspace - but these are no longer are supported.

I then tried to follow the guide, and it is possible to create a pass-through query with a compound set of statements separated by semicolon.

However, when I save such query, it is just marked as a normal pass-through query, and the Type property doesn't indicate compound.

Confusing?

/gustav
0
 
LVL 75
ID: 39269643
Gustav ... if you don't know, there is no hope :-)

I've never seen the term in Access ever. Interesting. I discovered a new VBA keyword last week also:

Erase

Check help for details. Has to do with clearing an Array.

mx
0
 
LVL 51

Author Comment

by:Gustav Brock
ID: 39269675
Well, thanks, but I have my black or at least grey holes. And the now obsolete ODBCdirect workspace is one of them.

Perhaps these compound queries were thought out but never implemented?
At least it is strange that neither Bing or Google returns a single hit on this type constant except the several places where the Enum is listed.

The Erase I faintly recall to have seen but I have never used it.

/gustav
0
 
LVL 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 600 total points
ID: 39269933
Never heard the term before either.  I would assume you conjecture is correct; it was related to ODBCDirect Datasources.   There were few (if anyone) that ever used them.

Think I've used a ODBCDirect workspace once in the last twenty years.  I wanted to run a query asynch and that was the only way to do it.

Have heard of Erase though and have used it many times.

Jim.
0
 
LVL 51

Author Closing Comment

by:Gustav Brock
ID: 39286392
Thanks for your input.

The conclusion seems to be, that this type of query may have been associated with ODBCdirect workspaces only. As these are obsolete now, so is this type of query.

The on-line help, however, is silent about this.

/gustav
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question