command used to change the contents of the primary key ?

jazzz345

What is the command used to change the contents of the primary key permanently in the table in Navision 4.0?

Savatage

you mean you would like to rename some key fields?

einsTeIn.NET

You can use

RENAME

but this operation might take a very long time.
For normal it is better to create a new record and delete the old one. But it depends on what you exactly want to do.

kine

einsTeIn.NET wrote:

You can use

RENAME

but this operation might take a very long time.
For normal it is better to create a new record and delete the old one. But it depends on what you exactly want to do.

This is dangerous! If you do not know all consequences, do not use this "quick" way, because it will took you much more time to solve the problems...

DenSter

einsTeIn.NET wrote:

For normal it is better to create a new record and delete the old one. But it depends on what you exactly want to do.

No most definately NOT the way to go for regular code. There is a reason why there is a RENAME operation, it takes care of all table relationships for you. Only go the delete/insert route if you know ALL relationships and you explicitly take care of those yourself. Other than that, as a general rule you should always use RENAME.

einsTeIn.NET

As I said.

einsTeIn.NET wrote:

But it depends on what you exactly want to do.

DenSter

You said:

einsTeIn.NET wrote:

For normal it is better to create a new record and delete the old one.

Which I interpreted as an advice from you that you think this is "the normal, regular, recommended" way to do this, when in fact it is a "last resort, only in exceptional cases, and only if you are well aware of all implications" way of doing it.

einsTeIn.NET

Oh.... indeed it is normal! ...depending on what you want to do. Take a look at e.g. Sales Quote -> Make Order.
But I agree with you, my first post could be capable of being misunderstood. But I thought only an advise to RENAME isn't the whole truth. What do you think?

kine

You cannot tell whole truth each time... ;-) People must be prepared for whole truth... Give the whole truth into hand of unprepared man and he will screw it and use it as he wish, mainly if it can hurt someone... :whistle: