Add / Remove FILTER from existing DBFILTER()

[AUGE_OHR]

hi,

guess i have use

Code: Select all

SET FILTER TO FIELD->AAA = "ABC" .AND. FIELD->BBB = "EFG"

and i want to "add" more ... how under HMG
also how to "remove" Part of DBFOLTER()

[mol]

If you want to add something new:
cNewFilter := dbFilter() + ".and." + cExpression
Set Filter to
set filter to cNewFilter

you can use dbClearFilter() instead of SET FILTER TO

for changing something, the best way is removing defined filter and defining it again, in my opinion.

[AUGE_OHR]

hi Mol,

Code: Select all

cNewFilter := dbFilter() + ".and." + cExpression
Set Filter to
set filter to cNewFilter

hm ... DBFLTER() return String not Codebock as i expect

for changing something, the best way is removing defined filter and defining it again, in my opinion.

you are right, it is (much) more work to "remove" a Part than create a New FILTER

[serge_girard]

Jimmy,

Maybe this works:

Code: Select all

cNewFilter := dbFilter() + ".and." + &cExpression
or this
cNewFilter := dbFilter() + .and. + &cExpression

Serge

[mol]

If you have filter expression from dbFilter(), you can easy change it codeblock:

Code: Select all

cNewFilter := "{||" +  dbFilter() +".and." + cExpresion +"}"
bNewFilter := &cNewFilter