Multiple SETRANGE

jhanvincent14 · 2016-10-20

hello good day. Can anyone tell how to setrange with same column with different values(3 values). I've tried this code

recBFOutputs.SETRANGE(recBFOutputs."Output Classification",recBFOutputs."Output Classification"::"Aquastar Local Orders",recBFOutputs."Output Classification"::"RK Activation",recBFOutputs."Output Classification"::"RK Feed Material");

but it gives me this error A maximum of 3 parameters must be used when calling the function

Thanks in advance

Kishorm · 2016-10-20

You need to use SETFILTER instead...

recBFOutputs.SETFILTER("Output Classification",'%1|%2|%3',
  recBFOutputs."Output Classification"::"Aquastar Local Orders",
  recBFOutputs."Output Classification"::"RK Activation",
  recBFOutputs."Output Classification"::"RK Feed Material");

Kishorm · 2016-10-20

You need to use SETFILTER instead...

recBFOutputs.SETFILTER("Output Classification",'%1|%2|%3',
  recBFOutputs."Output Classification"::"Aquastar Local Orders",
  recBFOutputs."Output Classification"::"RK Activation",
  recBFOutputs."Output Classification"::"RK Feed Material");

RockWithNAV · 2016-10-20

You need to use SETFILTER. Write the code as suggested by Kishoram and then let us know.

jhanvincent14 · 2016-10-24

thanks a lot

Multiple SETRANGE

Best Answer

Answers

Categories