Option field setrange

Pagot

Is there a way to avoid having to repeat several code lines if the value of an option field can be eg. all values except one. It seems not to work with "<>" or "%1|%2"?


Record.setrange("Option Field",Record."Option Field"::option1);
..

Record.setrange("Option Field",Record."Option Field"::option2);
..

Thanks,

mohana_cse06

DId you try

Record.SETFILTER("Option Field",'<>%1',"Option Field"::option);

Pagot

Indeed, I setfilter works fine. I forgot the obvious. Thanks!

mohana_cse06

Pagot wrote:

Indeed, I setfilter works fine. I forgot the obvious. Thanks!

Welcome