Setting Filter in Code

Wil Andrews

Delphi Developer

Tue, 27 Jun 2000 03:00:00 GMT

Setting Filter in Code

I can't seem to be abe to write code which sets a filter.

Consider a field, "Payee" in Table1.

I want to write some code like:

Table1.Filter:= . . . . . .

Case 1.
Set the filter so that only records with the field "Payee" = 'Eve'

Case 2
Set the filter so that only records with the field "Payee" = 'Eve' or
"Payee = 'John'

Help will be appreciated.

Wil

Brian Bushay Tea

Delphi Developer

Wed, 28 Jun 2000 03:00:00 GMT

Re:Setting Filter in Code

Quote

>Table1.Filter:= . . . . . .

>Case 1.
>Set the filter so that only records with the field "Payee" = 'Eve'

Table1.filter = 'Payee = '+QuoteStr('Eve');

Quote

>Case 2
>Set the filter so that only records with the field "Payee" = 'Eve' or
>"Payee = 'John'

Tbl1.filter='Payee = '+QuoteStr('Eve')+' or Payee ='+QuoteStr('Jhon');

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

Wil Andrew

Delphi Developer

Wed, 28 Jun 2000 03:00:00 GMT

Re:Setting Filter in Code

Thanks for the info. I never knew that the QuotedStr function was
present. Just to keep set the record straight, its name is "QuotedStr"
not "QuoteStr".

Thanks for the help.
Wil

Quote

Brian Bushay TeamB wrote:
> >Table1.Filter:= . . . . . .

> >Case 1.
> >Set the filter so that only records with the field "Payee" = 'Eve'

> Table1.filter = 'Payee = '+QuoteStr('Eve');

> >Case 2
> >Set the filter so that only records with the field "Payee" = 'Eve' or
> >"Payee = 'John'

> Tbl1.filter='Payee = '+QuoteStr('Eve')+' or Payee ='+QuoteStr('Jhon');

> --
> Brian Bushay (TeamB)
> Bbus...@DataGuidance.com

Brian Bushay Tea

Delphi Developer

Thu, 29 Jun 2000 03:00:00 GMT

Re:Setting Filter in Code

Quote

>Thanks for the info. I never knew that the QuotedStr function was
>present. Just to keep set the record straight, its name is "QuotedStr"
>not "QuoteStr".

myspelling slips with aout a syntax checker ;-( quotedStr is correct

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

Other Threads

1. Set filter by code

2. filtering on a filtered set, possible?

3. TTable.filter - How to set a partial filter

4. Setting BDE settings from code

5. Setting Range or Filter in a master/detail

6. Setting Filter

7. Help) How to set TBDEDataSet.Filter string?

8. Filtering on a date field set to NULL

9. Letting the user customize reports by filtering records and setting sorting/grouping levels at run time

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