how to filter substring ?

Diwan P. Ariana

Delphi Developer

Sat, 12 Jan 2002 03:00:00 GMT

how to filter substring ?

Hi there,
How to filter a field string equal to a substring through filter
property in a table component? For example
a CITY field in a data set contains [Battle Creek, Mill Creek. Stann
Creek District, Ann Arbor]
What is the filter expression to filter CITY that contain 'Creek' ?

What wild character(s) that can be applied to filter expression other
than '*' ?

Thank you.

Ariana

Steve Fischkoff (Tea

Delphi Developer

Sun, 13 Jan 2002 03:00:00 GMT

Re:how to filter substring ?

On Tue, 27 Jul 1999 13:46:45 -0700, "Diwan P. Ariana"

Quote

<arian...@pilot.msu.edu> wrote:
>Hi there,
>How to filter a field string equal to a substring through filter
>property in a table component? For example
>a CITY field in a data set contains [Battle Creek, Mill Creek. Stann
>Creek District, Ann Arbor]
>What is the filter expression to filter CITY that contain 'Creek' ?

>What wild character(s) that can be applied to filter expression other
>than '*' ?

>Thank you.

>Ariana

You can't do it that way. You'll have to write a custom filter event
handler (OnFillterRecord) where you test for the existence of the
substring and set the Accept variable accordingly.

Steve F (Team B)

Brian Bushay Tea

Delphi Developer

Sun, 13 Jan 2002 03:00:00 GMT

Re:how to filter substring ?

Quote

>How to filter a field string equal to a substring through filter
>property in a table component? For example
>a CITY field in a data set contains [Battle Creek, Mill Creek. Stann
>Creek District, Ann Arbor]
>What is the filter expression to filter CITY that contain 'Creek' ?

There isn't one. You need to write your own OnfilterRecord event handler to
handle this.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. substring matching in filters, and partial compare (d3)

2. Substring filter

3. find a substring with the Filter method

4. Dynamic Filter on TCustomADODataset where filter field data type change

5. How to filter a Lookup directly without filtering the Table

6. Filtering table already filtered .....

7. Partial filter strings Filters ?

8. Help, Multiple Filters Using the Filter Property

9. Filter Problems - Does The Filter Property Required CachedUpdates True

10. IBTable.Filter or IBQuery.Filter