Drew Wutka
DWUTKA at Marlow.com
Mon Jan 10 18:47:53 CST 2011
Jet. At least I just kinda figured that ADO would be telling Jet, hey, 'return qryXXX'. Ironically, I almost never used DAO, even when developing within Access, which is probably why the wildcards were the first thing to pop into my head as the issue. That little bugger caused me a real headache over a decade ago, when working with ADO in VB6. It wasn't long after I started in Access, that I got into VB and asp. ADO provides the versatility of jumping between various data sources, so I just kept everything in ADO. The only time I ever used DAO was when I needed functionality that only DAO provided (like running a custom function inside a query). Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, January 10, 2011 4:45 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Record Set Puzzler involving Query withCriteria Doh... I never use ADO recordsets so I didn't realise that it used SQL wilscards, but it makes sense. One more reason to stick with DAO :-) It seems logical to me that ADO evaluates the sub query as well - what else would do it? -- Stuart On 10 Jan 2011 at 11:06, Drew Wutka wrote: > I did... it was on a hunch. His issue is the # is not a wildcard > character in ADO. > ... > > This is kind of interesting. I think this means that ADO is actually > reading the SQL of Query1 and interpreting the SQL itself. Go figure. > > I can't find numeric wildcards for ADO, just % and _ which are * and ? > in Jet. > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.