Odd SETRANGE and Boolean behavior

spider1269
spider1269 Member Posts: 77
in NAV Three Tier
I came across an odd behavior with SETRANGE and booleans and I can't figure it out. I have 2 boolean filters that when run don't do anything. All records are returned. When I add the 3rd SETRANGE below (for testing) it then works as expected. I've tried using SETFILTER as well with no luck.

SalesHeader.SETRANGE(Processed,TRUE);
SalesHeader.SETRANGE(Updated,FALSE);

SalesHeader.SETRANGE(UpdatedDate,0DT);

Best Answer

  • spider1269
    spider1269 Member Posts: 77
    Answer ✓
    This is really odd. I've been working on this for 30 minutes. Recompiled, restarted NAV, etc. Now all of a sudden it started to work. No explanation.

Answers

  • spider1269
    spider1269 Member Posts: 77
    Answer ✓
    This is really odd. I've been working on this for 30 minutes. Recompiled, restarted NAV, etc. Now all of a sudden it started to work. No explanation.

Categories