• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

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

PS: It is not just a select query with more than one criteria.
0
Gustav Brock
Asked:
Gustav Brock
4 Solutions
 
Bill RossCommented:
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
 
MacroShadowCommented:
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
 
Gustav BrockCIOAuthor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Gustav BrockCIOAuthor Commented:
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
 
Gustav BrockCIOAuthor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
Gustav BrockCIOAuthor Commented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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
 
Gustav BrockCIOAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now