2009 SP1 and 4.0 Matrix forms

tedcjohnstontedcjohnston Member Posts: 41
edited 2009-09-07 in NAV Three Tier
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.

Answers

  • ara3nara3n Member Posts: 9,256
    There is a change in how Case statement are case sensitive I believe.

    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    ara3n wrote:
    There is a change in how Case statement are case sensitive I believe.
    Yes, it was one of biggest surprise with technical upgrades to NAV2009.

    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;
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • ara3nara3n Member Posts: 9,256
    I believe the main reason for this was that is how C# works and they wanted to be compatible with translating CAL to C#
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • apankoapanko Member Posts: 70
    Hi,
    This issue is described in KB article 971958.


    thanks to deef09
  • David_SingletonDavid_Singleton Member Posts: 5,479
    ara3n wrote:
    There is a change in how Case statement are case sensitive I believe.
    Yes, it was one of biggest surprise with technical upgrades to NAV2009.

    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;

    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.
    David Singleton
Sign In or Register to comment.