Re: How to make filter case sensitive?
- From: Paul Clement <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx>
- Date: Tue, 16 Jan 2007 08:22:53 -0600
On Fri, 12 Jan 2007 12:00:00 -0800, Andrew <Andrew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
¤ Hello, friends,
¤
¤ I am using VB6 and ADO 2.5 to query an Access database. I am using filter to
¤ get certain records I need after filling up a record set:
¤
¤ recSet.Filter = "gbkeycode = '" & keyCodeStr & "'"
¤
¤ However, this filter is NOT case sensitive. As a result, I got wrong records.
¤
¤ How to make this filter case sensitive? Thanks a lot.
As posted in another newsgroup, there is no support for case sensitivity in Access.
You can use the StrComp function in a SQL query but I don't know that it will work with the Filter
property.
Paul
~~~~
Microsoft MVP (Visual Basic)
.
- Prev by Date: Re: Read certain bytes from binary file
- Next by Date: How do I serialize an object into an xmlnode
- Previous by thread: Re: How to make filter case sensitive?
- Next by thread: RE: Problem calculating estimated time remaining against progress
- Index(es):
Relevant Pages
|
