Setfilter with an option field

Jesus
Jesus 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 Posts: 23
    Hi,

    You need to use something like:

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

    Try this.
  • you cant use setfilter with a blank value
    you have to use setrange
  • jm
    jm 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