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
Solved

QyeryDef.Type dbQCompound

Posted on 2013-06-23
9
388 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
9 Comments
 
LVL 14

Assisted Solution

by:Bill Ross
Bill Ross earned 200 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 100 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 49

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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 49

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 49

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 49

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 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 200 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 49

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

790 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