Setting Filter in multiple field in the same record

SimoGsi

Hello All,

I am developping a function in C/Al , i wanna set a filter for 3 fields on one table
to do this i do :
rec.SETFILTER(Field,'<>%1','AR*');
rec.SETFILTER(Field1,'<>%1','TR*');
rec.SETFILTER(Field2,'<>%1','VR*');

but i doesn't seem to work when i iterate through this record(it still generating all records including ones staring with AR.......)

Can you pls help me to resolve this problem

Thank you in advance

jemmy

Hi SimoGsi,

yeah, you couldn't use '<>%1' in SETFILTER.

Try to rewrite your code like these:

rec.SETFILTER(Field,'<>AR*');
rec.SETFILTER(Field1,'<>TR*');
rec.SETFILTER(Field2,'<>VR*');

hope this helps,

Jemmy

SteveO

That's not entirely true...
You can use '<>%1' in SETFILTER but you cannot use the * wildcard when using <> unless you are using the SQL version.

Try this (for example).

SETFILTER(FIELD1, '<AR|>AR*');

I have tried quickly myself on a few records and it seems to work fine.

jemmy

Hi Steve,

Thanks for the correction..

Jemmy

RobertMo

Haven't I already read this today?
Oh,yes...
http://www.mibuso.com/forum/viewtopic.php?t=4195