Primary key doubt

te6

hi all,

There is a rule saying that If the field is part of a primary key, it should have type Code.

What happens if the field is not part of type CODE..
I mean , should any errors be faced..

Any Advice
Thanks in Advance

SUNDAR....

Konrad

Where did you find this rule?

ebsoft

te6 wrote:

hi all,

There is a rule saying that If the field is part of a primary key, it should have type Code.

What happens if the field is not part of type CODE..
I mean , should any errors be faced..

Any Advice
Thanks in Advance

SUNDAR....

A primary key could even be a Integer. Even a single char!

ebsoft

Konrad wrote:

Where did you find this rule?

Maybe in a book... "Programming for newbies" or for dummies!

Alex_Chow

A primary key can be anything. Check out the Item Ledger Entry. This is a perfect example of where Integer is the primary key.

DenSter

You can use any field and/or field combination as the primary key, there is no technical reason not to use a Code field.

The 'rule' is for certain types of tables in NAV, they are like common practice. For master tables for instance, the 'rule' is to use a Code20 type field. That doesn't mean that you can't create a master table with an integer field as the primary key, but by using those common practices your work will feel familiar to your users.

kine

For me it is out of context. If I read this sentence, for me it means that if you want to use some text as part of primary key, recommanded is to use Code type an not Text type.