Setfilter with an option field

Jesus
Jesus Member Posts: 2
edited 2005-02-21 in Navision Attain
Hello.

I need to make a filter to a table using the value of one option field. The value of this option field has blanks so the setfilter command doesn't run. I've try to use the number of the option but also doesn't work.

Can anybody help me?

Thank you very much.

Comments

  • alanperu
    alanperu Member Posts: 23
    Hi,

    You need to use something like:

    record.SETRANGE(OptionField,record.OptionField::" This has spaces");

    Try this.
  • PEzechiels
    PEzechiels Member Posts: 83
    you cant use setfilter with a blank value
    you have to use setrange
  • jm
    jm Member Posts: 156
    Hi,

    try this:
    record.SETRANGE(OptionField,record.OptionField::"n");

    n is the number of the option starting with 0.

    br
    Josef Metz
    br
    Josef Metz

Categories