Filter a option field

The option field can be referenced by name or by number from 0 to n. Blank is usually referenced as 0.

Try this code below


IF Customer.Blocked <>0
THEN block := text1;

Regards

MAJB

I think that there is good place to mention some rules for using option data type:

1) When possible and you need to use specific option value, use the operator :: - it means something like myOptionVar::"Option 1". You can write it as myOptionVar::"1" and after reopening the object NAV will automatically "expand" the number by correct value.
-easy
-readable

2) When you need to pass some option into some function, you can use integer variable, but use it only with caution and in cases, when you are working only with the variable, not with some specific values (you do not need use "constants" in the code).

3) Never use integer constants instead option constant in the code. Nobody else will know what does it mean. It is not possible to maintain that (e.g. in case when bad things happen like when you need to insert new option into existing one - but this is example of really bad thing).

4) Never, NEVER, use text constant in connection with option value (like myOptionVar := 'Option 1'). This will not work in another language than you wrote it, it will not work when somebody change the caption on the option, simply - It will not work... (with exceptions)

5) You can think about Option as about integer, but only for math operations with the options like comparison, adding, subtracting. But when comparing, use point 1 to compare with specific value...

Of course, this is example how to precede the possible problems...