ADO Recordset Find method is case insensitive ?

[Alex]

Hello all,

we figured out that ADO Recordset Find method applied to
detached and in-memory recorsets is case-insensitive !?
I mean:
rs.find "Name = 'aaa'" finds also 'AAA' and so on...

We found nothing regarding this issue at Microsoft site
and MSDN

Looks scaring...

Can anybody say something about this ?

Thanks in advance

Alex.

[Paul Clement]

On 25 Jul 2000 06:12:04 -0700, "Alex" <aedelman@mannanetwork.com> wrote:

¤
¤ Hello all,
¤
¤ we figured out that ADO Recordset Find method applied to
¤ detached and in-memory recorsets is case-insensitive !?
¤ I mean:
¤ rs.find "Name = 'aaa'" finds also 'AAA' and so on...
¤

If this is Microsoft Access, Jet treats all queries as case insensitive.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)