TTable.filter - How to set a partial filter

Nicklas N. Eid

Delphi Developer

Sat, 17 Mar 2001 03:00:00 GMT

TTable.filter - How to set a partial filter

I'm trying to set a filter that can sort out any data containing
*something*. I have managed to set a filter that sorts out data starting
with an unknown *something with the FilterOptions. Is it possible to do
this with TTable or do I have to use a query??
(code examples?)
Best regards,
Nicklas Eid

Dennis Youn

Delphi Developer

Sat, 17 Mar 2001 03:00:00 GMT

Re:TTable.filter - How to set a partial filter

Quote

>I'm trying to set a filter that can sort out any data containing
>*something*. I have managed to set a filter that sorts out data starting
>with an unknown *something with the FilterOptions. Is it possible to do
>this with TTable or do I have to use a query??

Yes it is possible, as I have just recently found out on a single unit
filters are much slower than a sql statement. I would definately go with the
SQL.

if you need some sql examples, ask away....

Steve Fischkoff (Tea

Delphi Developer

Sat, 17 Mar 2001 03:00:00 GMT

Re:TTable.filter - How to set a partial filter

On Tue, 29 Sep 1998 22:03:07 +0200, "Nicklas N. Eid"

Quote

<nicklas....@telehuset.no> wrote:
>I'm trying to set a filter that can sort out any data containing
>*something*. I have managed to set a filter that sorts out data starting
>with an unknown *something with the FilterOptions. Is it possible to do
>this with TTable or do I have to use a query??
>(code examples?)
>Best regards,
>Nicklas Eid

You can put code in the TTable OnFilterRecord event that filters based
on anything you can code. Specifically, check what you need to and
then set the Accept variable appropriately.

Steve F (Team B)

Other Threads

1. Partial filter strings Filters ?

2. Partial match anywhere Filter in the Filter property

3. partial string filter in TTable

4. filtering on a filtered set, possible?

5. How to filter/set range on a TTable?

6. REQ: Help setting filter on ttable

7. partial filtering?

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

9. Filtering for a partial string in a field via Ado, DBase

10. Filters and partial strings