ClientDataset Filter and Wildcards

[Dave1024]

Hi -

I am using Delphi 2009 and cannot seem to find a way to use the "filter" property to filter for wildcards properly. Basically, I would like to be able to use wildcards in the filter property to filter recrods that contain the string the user enters.

I can get it to work sort of,using one wildcard such as,,

CDS_FIND.Filter := Fname + ' like '+ QuotedStr(ToFind.Text + '*') ;

Where "Tofind" represents the control holding the criteria to search for.


But I cant get it to work like this..

CDS_FIND.Filter := Fname + ' like '+ QuotedStr('*'+ToFind.Text + '*') ;

So it matches any results that "contain" the search criteria.

Reading some information on the subject adn it says that Clientdataset filter returns partial matches by default. But this simply is not the case.

I want to be able to filter records based on criteria entered by the usesr and use the "FindNext" - "FindFirst" and other functions to let the user navidate the results (or at least set the fitler so they can navigate t=he the sub-set of records.

Any help on this would be much appreciated.

Cheers.,.

Dave.

 

[majlumbo]

* is not a valid wildcard character in databases.
it is usually % or _

look here for an explanation

http://www.techonthenet.com/sql/like.php

 

[Dave1024]

Hi -

Actually "*" is a valid wildcard character in Interbase / Firebird and is quated in an example by Cary Jenson on the subject here:

http://edn.embarcadero.com/article/29271

Thanks,

 

[Dave1024]

Dam, cant seem to see the feature to "edit a post" (its been a while.)

Also meant to say that I have tried other wildcard characters, just in case that was an issue, still no joy.

Thanks.

Dave.

 

[majlumbo]

Sorry, haven't worked with Interbase/Firebird.

Anyway, another link..

This one explains how to filter a Paradox table, they use the '*', but do not use 'like' in the filter expression. Hopefully this one helps..

http://www.delphi3000.com/articles/article_650.asp?SK=