Using "<>" at field filter

RachelSoon

Hi All,
I am using "<>" operator at field filter for Customer No, it doesn't seem working.

I fill in <>A at the field filter, but the customer No which start with 'A' does not being filter.

How can i exclude certain customer no from the list?

thank you.

SteveO

Hi Rachel,

Try if you are using Navision proprietary database:
Customer.SETFILTER("No.", '<%1 | >%2', 'A', 'A*')

If you are using SQL then I believe that
Customer.SETFILTER("No.", '<>%1', 'A*') works

kine

See http://www.mibuso.com/forum/viewtopic.php?t=5650
or http://www.mibuso.com/forum/viewtopic.php?t=4067

eromein

Click this link to download the Navision Bible!