Solved

QyeryDef.Type dbQCompound

Posted on 2013-06-23
9
380 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

816 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now