auto increment

flyingjujuflyingjuju Member Posts: 35
edited 2012-07-02 in Navision Financials
Hello,

i want to use the auto increment in the database for a code field.
It is the primary key in the table.

How can I create this auto increment ? it is a property for the field ?
I have to do it in code ?

Thank you for your help

Cordially

Answers

  • ChinmoyChinmoy Member Posts: 359
    You can link it to a Number Series... however, you have to anyways write some code to generate the new number.

    Chn
  • ufukufuk Member Posts: 514
    Autoincrement property can be used only for numeric type fields (integer, biginteger)
    If you use code type field then you have to do some development (using no. series or not)
    Do you really require an alphanumeric pk? Why do you use code type?
    Ufuk Asci
    Pargesoft
  • flyingjujuflyingjuju Member Posts: 35
    you're right. I will use an integer primary key.
    What is the property to be used for autoincrement?

    Can you explain please?
  • udayrmerudayrmer Member Posts: 171
    Go to properties of field, change autoIncrement = yes
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • flyingjujuflyingjuju Member Posts: 35
    i don't have this property in the field in the table

    I'm in navision financial 2.6
  • udayrmerudayrmer Member Posts: 171
    Then you should write code it
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
Sign In or Register to comment.