Reg Filtering

smartsri

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

remco_rausch

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

Mbad

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.