How to create line No ?

Sai_123Sai_123 Posts: 7Member
edited 2018-10-04 in NAV Three Tier
rgqru6adjkon.jpg
gtp3xbd61ijb.jpg
Hey ! Actually I'm new learner in dynamic nav Actually i created two tables and in Pages One cardpage and Listpage, And My Line Number Auto increment Is working in table when i Run, But Not working In CardPage When i do Run. So kindly help me up Guys.! :)

Answers

  • Sai_123Sai_123 Posts: 7Member
    If anyone Knows Kindly let me know!It would be Helpful :)
  • navuser1navuser1 Posts: 1,232Member
    Use Autosplitkey propertities in Page level
    Now or Never
  • Sai_123Sai_123 Posts: 7Member
    Didn't work ! i used that properties..!
  • aceXaceX Posts: 146Member
    In NAV, you can use Autosplitkey property for this purpose. But when you use that property the values are incremented for 1. This is practice mostly for ledger tables where Entry No. is the key. In your case if this is the Line table where Line No is one of the keys, you should use function or insert the code OnInsert trigger on your table:

    global var Record YourTable
    global var Integer LineNo


    function GetLineNo
    -return value Integer

    OnInsert
    GetLineNo(Rec);


    LOCAL GetLineNo:Return Integer
    IF YourTable.FINDLAST THEN
    LineNo := YourTable."Line No." + 10000
    ELSE
    LineNo := 10000;

    EXIT("Line No.");


    I hope this can help you. But before continue to develop in NAV, please read some books. Here it is one example:
    http://www.mergetool.com/Data/MGT/CalProgGuide.pdf
  • Slawek_GuzekSlawek_Guzek Posts: 1,564Member
    @acex I think you've mistaken AutoIncrement with AutoSplitKey

    @sai_123 AutoSplitKey is the property to be used, but it only works when the integer field you want to be auto-numbered is a part of a primary key on a table, and only when the integer field is the last one in the PK definition. If this is not the case you need to add some code to handle this.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • krikikriki Posts: 8,541Member, Moderator
    [Topic moved from 'Navision DOS' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
Sign In or Register to comment.