Options

Reg Filtering

smartsrismartsri Member Posts: 10
Hi,

I want to Filter Records from Customer table that Customer No. Should not be start with 10.

So I have put coding Like.

Cust.setfilter("No.",'<>%1','10*')

Its not working...
Anybody help me...

Sridharan
Sridharan

Comments

  • remco_rauschremco_rausch Member Posts: 68
    Hi,

    I had a play with the filters and it seems that the * seems to not work as I expected it to.

    I tried
    Cust.SETFILTER("No.",'<>%1*',10);
    but that shows all the records.

    In the end I got it to work with as follows:
    Declare a text constant:
    Filter <>%1*

    Cust.SETFILTER("No.",STRSUBSTNO(Filter,10));

    Hope that helps,

    Remco
  • MbadMbad Member Posts: 344
    Dont hardcode filters. Create a textfield on the appropriate setup table(would be sales & rec setup), and make the customer type in the filter. Then apply it on the form.
Sign In or Register to comment.