Board index » delphi » Help, Multiple Filters Using the Filter Property

Brian Huff

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Help, Multiple Filters Using the Filter Property

When filtering a TTable, how is it possible to set the filter for more
than one field?
I would like to setup something like this....

In the OnFilterRecord of TTable1....

Accept := field1 = Value1 and Field2 = Value2l;

How is this done...  I can accept one value, but not two....

Anyhelp would be greatly appreceiated...

email - br...@idisoft.com

Thanks in advance!

 
Michael Heft

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Help, Multiple Filters Using the Filter Property


How about Accept := ((Field1 = Value1) and (Field2 = Value2))?
   (with the TTable filtered property set to True)

This should work if you just want to filter based on two values.

Mike Hefty

Quote
Brian Huff wrote:

> When filtering a TTable, how is it possible to set the filter for more
> than one field?
> I would like to setup something like this....

> In the OnFilterRecord of TTable1....

> Accept := field1 = Value1 and Field2 = Value2l;

> How is this done...  I can accept one value, but not two....

> Anyhelp would be greatly appreceiated...

> email - br...@idisoft.com

> Thanks in advance!

Other Threads

1. Filtered property but no Filter property?

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

3. Partial match anywhere Filter in the Filter property

4. Filter a table using AND or filtering 2 fields at onces

5. Table.Filter: Filtering between dates - Help needed!!!

6. Using the Filter property on a TQuery

7. Using LIKE in TTable.Filter property (Delphi 3.0)

8. Using the Filter property on a TQuery

9. How can I select NULL Blob fields in ADOTable using Filter property

10. Filter-Property could not be used with detail-tables