2009 SP1 and 4.0 Matrix forms

tedcjohnston
tedcjohnston 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

  • ara3n
    ara3n Member Posts: 9,258
    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_Guzek
    Slawek_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
  • ara3n
    ara3n Member Posts: 9,258
    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
  • apanko
    apanko Member Posts: 70
    Hi,
    This issue is described in KB article 971958.


    thanks to deef09
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Slawek Guzek wrote:
    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

Categories