Very Computer

by **KIM969** » Wed, 29 May 1996 04:00:00

Okay... all i want to do is use opal to set a filter on a category field.
normally i right click on the field and type in the filter (its a
tableframe)
i was hoping someone could tell me how to use a button to set the field
filter automatically. its a paint data base and the category is color
(field name is color), and i would like to filter to view only those in
the "Blue"
category. Thank you

by **Jeff Benshetle** » Wed, 29 May 1996 04:00:00

> Okay... all i want to do is use opal to set a filter on a category field.
> normally i right click on the field and type in the filter (its a
> tableframe)
> i was hoping someone could tell me how to use a button to set the field
> filter automatically. its a paint data base and the category is color
> (field name is color), and i would like to filter to view only those in
> the "Blue"
> category. Thank youThis may not be 100%, but its a start.

*You have a tableframe on the form, with global scope, lets call it
tblFrm.
*Create a button on the form. Using the object Explorer, edit the
pushButton method.

method pushButton(var eventInfo Event)
var
criteria dynArray[] AnyType
endVar
criteria["Color"]="Blue"
tblFrm.setGenFilter(criteria)
endMethod

I'm not certain you can apply a filter directly to a tableframe (I think
so...) but I know you can apply a filter to a TCursor or Table. If you
apply a filter to a report note that the report must be put into design
mode and then run for the filter to take effect.

by **Thor Warbe** » Thu, 30 May 1996 04:00:00

>Okay... all i want to do is use opal to set a filter on a category field.
>normally i right click on the field and type in the filter (its a
>tableframe)
>i was hoping someone could tell me how to use a button to set the field
>filter automatically. its a paint data base and the category is color
>(field name is color), and i would like to filter to view only those in
>the "Blue"
>category. Thank you

Hello Kim,

My need for filtering ( in Pdox 4.5 !! - any newer version is awful
slow so I am stuck to 4.5. And feeling well.) is provided by this
button:

var
f Form
endVar

attach(f)
Action(DataEndEdit)

f.menuAction(MenuFormOrderRange)
f.sida.MoveTo()
sleep(500)
Action(DataBeginEdit)

Regards
Thor Warberg

Very Computer

Filter question

Filter question

Filter question

Filter question