kriki: NAV2013 FINDSET

[Blog bot]

RESET;

IF FINDSET THEN

REPEAT

MESSAGE(’A:%1′,Code);

UNTIL NEXT(-1) = 0;

RESET;

ASCENDING(FALSE);

IF FINDSET THEN

REPEAT

MESSAGE(’B:%1′,Code);

UNTIL NEXT(-1) = 0;

RESET;

IF FINDSET THEN

REPEAT

MESSAGE(’C:%1′,Code);

UNTIL NEXT = 0;

Question: which of these 3 IF-THEN-REPEAT-UNTIL will give all records? Which generates an error? Which gives only 1 record?

A: gives only 1 record

B: gives the all data and no error

C: gives the all data and no error

Seen something weird? Did you try these on NAV 2009R2?

Yes, there is something weird if you tried it on NAV 2009R2. NAV 2009R2 will give error "You can only use the FINDSET function with an ascending key order." for B!

BUT on NAV2013 it does work and it gives all records starting with the last one (like it should be)!



Читать дальше