ADO and Union Query Results

[michael montagne]

I'm using ADO from AutoCad to try and resolve this query from an
Access2000 database:
SELECT * FROM qryAllnotes WHERE tblProjNotes.KeyText = '*grade*';

It doesn't return any records, but without the WHERE clause, it does. I
know there are records there because I pasted into the Access query
builder and I get two records back. qryallnotes is a union query (if
that matters).

This is the string to open the recordset:
oRSNotes.Open sSQL, oDB1, adOpenStatic, adLockReadOnly

-mjm

[Salad]

michael montagne wrote:

I'm using ADO from AutoCad to try and resolve this query from an
Access2000 database:
SELECT * FROM qryAllnotes WHERE tblProjNotes.KeyText = '*grade*';
Are you searching for records where KeyText begins/ends with the word
*grade* or are you searching for records that contain *grade*?

It doesn't return any records, but without the WHERE clause, it does. I
know there are records there because I pasted into the Access query
builder and I get two records back. qryallnotes is a union query (if
that matters).

This is the string to open the recordset:
oRSNotes.Open sSQL, oDB1, adOpenStatic, adLockReadOnly

-mjm

[michael montagne]

I want reords that contain "grade".

Salad wrote:

michael montagne wrote:

I'm using ADO from AutoCad to try and resolve this query from an
Access2000 database:
SELECT * FROM qryAllnotes WHERE tblProjNotes.KeyText = '*grade*';

Are you searching for records where KeyText begins/ends with the word
*grade* or are you searching for records that contain *grade*?

It doesn't return any records, but without the WHERE clause, it does.
I know there are records there because I pasted into the Access query
builder and I get two records back. qryallnotes is a union query (if
that matters).

This is the string to open the recordset:
oRSNotes.Open sSQL, oDB1, adOpenStatic, adLockReadOnly

-mjm

[Salad]

michael montagne wrote:

I want reords that contain "grade".

Salad wrote:

michael montagne wrote:

I'm using ADO from AutoCad to try and resolve this query from an
Access2000 database:
SELECT * FROM qryAllnotes WHERE tblProjNotes.KeyText = '*grade*';

Are you searching for records where KeyText begins/ends with the word
*grade* or are you searching for records that contain *grade*?

Then change = to LIKE.
WHERE tblProjNotes.KeyText LIKE '*grade*';

[Michael \(michka\) Kaplan [MS]]

If that does not work, then isn't there an issue with the preferred syntax
for the wildcard in ADO (vs. DAO) ?
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Salad" <oi*@vinegar.com> wrote in message
news:SI*****************@newsread2.news.pas.earthl ink.net...

michael montagne wrote:

I want reords that contain "grade".

Salad wrote:

michael montagne wrote:

I'm using ADO from AutoCad to try and resolve this query from an
Access2000 database:
SELECT * FROM qryAllnotes WHERE tblProjNotes.KeyText = '*grade*';

Are you searching for records where KeyText begins/ends with the word
*grade* or are you searching for records that contain *grade*?

Then change = to LIKE.
WHERE tblProjNotes.KeyText LIKE '*grade*';

[michael montagne]

I had tried like (bad me for not posting that version, I know it is
correct). It turns out that you need to use "%" for the wildcard.
Thanks both for your aid.

Michael (michka) Kaplan [MS] wrote:

If that does not work, then isn't there an issue with the preferred syntax
for the wildcard in ADO (vs. DAO) ?