I just upgraded my executables from 4.0 SP1 to 2009 SP1. Now my matrix forms do not populate. Example is the statistics form for the item card (Form 5827). In 4.0 SP1 and using 4.0 objects in 2009 pre SP1, the matrix worked (dates showed up in the right side and populated the fields). The form does work in CRONUS.
Any suggestions?
"There are only two truly infinite things: the universe and stupidity. And I am unsure about the universe." - Albert Einstein
Corollary- Build and idiot proof system and nature will build a better idiot.
0
Answers
I suggest to do a text compare for the forms and you'll find that DimCodeToOption function has changed to Text.
You could Just load the objects from 2009 and compile them.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Something what worked perfectly in NAV5 and former versions unexpectedly stop working in NAV2009, just because of introduced case sensitivity of CASE function.
@tedcjohnston:
CASE 'a' OF
'A' : THIS DOES NOT FIRE IN NAV2009 but DO in NAV5 and former
END;
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
This issue is described in KB article 971958.
thanks to deef09
You learn something every day. I have (since ver 1) assumed that CASE was case sensitive. I always use UPPERCASE if I do any text compares CASE or what ever. I would never have expected the above statement to work.