How to create line No ?

Sai_123
Sai_123 Member Posts: 18
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_123
    Sai_123 Member Posts: 18
    If anyone Knows Kindly let me know!It would be Helpful :)
  • navuser1
    navuser1 Member Posts: 1,334
    Use Autosplitkey propertities in Page level
    Now or Never
  • Sai_123
    Sai_123 Member Posts: 18
    Didn't work ! i used that properties..!
  • aceX
    aceX Member Posts: 166
    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_Guzek
    Slawek_Guzek Member Posts: 1,690
    @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
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'Navision DOS' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories