mibuso.com
Home› Navision Financials
Options

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

  • Options
    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
  • Options
    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
  • Options
    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?
  • Options
    udayrmerudayrmer Member Posts: 171
    Go to properties of field, change autoIncrement = yes
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • Options
    flyingjujuflyingjuju Member Posts: 35
    i don't have this property in the field in the table

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