[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.
>