Having some filter problems

[Mike Grigsby]

Would any of you happen to see anything wrong with this?

Got a memory form with a drop down list of categories (from the category file) to filter the child browse of dealers below it. In the BrowseFilter embed of the dealer browse procedure, I have the following filter:

ThisView{prop:Filter} = 'DEA:Category = '''&clip(CAT:Category)&''' '

The first category I select it gives me the right number of records. If I choose the last category, it is short one record (drops the last dealer with that category). Works perfectly with anything in between, and sometimes the first category is short the first dealer that matches it.

Does this sound familiar? This is a really basic browse and it includes the category in the view.

[Bruce]

Hi Mike,

When in doubt always use the session value. The filter should be...

ThisView{prop:Filter} = 'DEA:Category = '''&p_web.GSV('CAT:Category')&''' '

Cheers
Bruce