Setfilter

sabzam

Hi Everybody,

I have used the setfilter extensively but for some reason or another the following code is not working properly. Could anyone help me to solve this issue.

The code in question is:
Transactions.SETFILTER (OURREF, '<>%1&<>%2', 'SOR*','POR*');

Practically I am filtering a table by the OURREF field, where the field contents doesn't begin with SOR or POR.

For some reason they are still being extracted even though they begin with POR or SOR.

Jut

What do you mean by "even though they begin with POR or SOR".

Actually you filter condition just shows all records where OUREF does NOT start with SOR and POR what is equal to your statement that "they are still being extracted even though they begin with POR or SOR."

sabzam

Well actually that is what I want...I do not want those that begin with POR and SOR to be shown but they are still being shown

kapamarou

Does

Transactions.SETFILTER (OURREF, '<>SOR*&<>POR*')

Work??

Belias

http://www.mibuso.com/forum/viewtopic.php?t=23219&highlight=setfilter