Setfitler Problem

sabzam
sabzam Member Posts: 1,149
edited 2008-02-08 in NAV/Navision Classic Client
Dear All,

I am looking in a table using setfilter. It is working properly except for one case...when the data used as filter is 0 as test i.e. '0'; an error is being realeased stating that there is no record with field ''. The ambigous thing is that '' is never passed over but a '0' is passed besides there is an if statement to the find.

Has anyone got any idea why this may be happening?

Comments

  • jsnayberk
    jsnayberk Member Posts: 58
    Did you try this?
    SETFILTER("Name 2", '=%1', '');

    Regards
    --
    Josef Snayberk
  • sabzam
    sabzam Member Posts: 1,149
    Actually I have got the same coding but less specific; in other words I do not want to specifically look for '' but simply that when one of the fields used as setfilter is '' no error message is displayued but simply the next field is requested by the codeunit
  • jsnayberk
    jsnayberk Member Posts: 58
    I´m not sure I understood correctly what you are trying.
    Could you, for illustration, post a code sniplet with some comments of what is working an what not?
    --
    Josef Snayberk

Categories