[RESOLVED] ADODC Recordset.Find - Single Character Wildcard

[jm1248]

Sorry to be a bother again, but nowhere can I find
what the ADODC single-character wildcard is for the Find method.
Help says underscore (_) but it doesn't work for me.
e.g.:
Adodc1.Recordset.Find "Tag LIKE 'ab_d'"

*** Answer: ADODC doesn't support single character wildcards ***

Underscore works if it's run in an SQL statement:
e.g.
SQL="SELECT * FROM Table1 WHERE Title LIKE 'ab_d'"
Adodc1.RecordSource = SQL
Adodc1.Refresh

I could just use SQL, but I'm not sure what SQL statement
to use to do a Find within an existing record set. I can't use
a SELECT because the user may have changed a record that
would disappear with a new SELECT.

*** Answer: Unanswered ***

Also can't determine how to deal with finds where
the % and _ characters may be part of the search
pattern; e.g.: .Find "filename LIKE 'file_001.txt'" or
"Result LIKE '50%'". The backslash (\) Escape character
doesn't work as it does with MySQL.

*** Answer: Square brace literals - LIKE '50[%]' gets 50% and not 50lb ***

[brucevde]

The ADO Recordset Find and Filter methods do not support single character wildcards.

[jm1248]

Thanks Bruce,

Did they used to? The VB6 ADO Help suggests it did.
Anyway, I'm going to use a programatic find instead.

Re the Escape question: Can you tell me what the ADO
expects in the SQL string to denote a literal character?

" .. can't determine how to deal with finds where
the % and _ characters may be part of the search
pattern; e.g.: .Find "filename LIKE 'file_001.txt'" or
"Result LIKE '50%'". The backslash (\) Escape character
doesn't work as it does with MySQL."

Thanks,
John

PS: Your Canucks really abused my Leafs last night!

[si_the_geek]

When using like you can specify valid characters for a position by placing them in square brackets (eg: [0123456789] to allow a number), so you should be able to simply place the character on its own inside square brackets. (From memory, I haven't checked!)

[jm1248]

When using like you can specify valid characters for a position by placing them in square brackets (eg: [0123456789] to allow a number), so you should be able to simply place the character on its own inside square brackets. (From memory, I haven't checked!)

So 50[%] should get 50% and not 50lb?

[si_the_geek]

Correct... but I'm not sure if it accepts wildcards in that manner, so it may not return 50%

[brucevde]

So 50[%] should get 50% and not 50lb?

No. Find and Filter only support "Starts With" and "Contains" wildcard searches. Ie 'A%' and/or '%A%'.

[jm1248]

Thanks guys,

I'm using SQL statements for user searches with []'s to escape literals. Works fine.
I now only use ADODC.Find to reposition the recordset to its unique ID.