Setfilter with an option field

JesusJesus 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

  • alanperualanperu Member Posts: 23
    Hi,

    You need to use something like:

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

    Try this.
  • PEzechielsPEzechiels Member Posts: 83
    you cant use setfilter with a blank value
    you have to use setrange
  • jmjm 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
Sign In or Register to comment.