Item Table : Description Length

anirudh_laroiya

We are using Navision 3.7. In Item Table we have two fields for Description i.e. Description Text(30) & Description 2 Text (30). But some time we have larger description for an item. Where should we put that excess description, is there any separate table or field for that.
Please Reply

Anirudh

jsnayberk

It depends very much on what you would like to achieve with this additional information e.g. where you want to find it back.

If its just an additional text and has no special impact outside the items table an new field (e.g. Description 3 with may be 255 length) could help.

If you want to see the information in other parts of the application a lot of work will come up to you. You will have to implement the new field in all of the objects which you want to be aware of the new information.

The worst attempt however would be to expand an existing description field. If you choose this option you will first have to analyse all the appearances of this field in the entire application to fix the length of all variables and parameters where the content of this field is copied to to avoid a text overflow at runtime.

Regards

idiot

This topic has been discussed many times. Please do a search. The decision depends solely on your future scalability & integration with other applications & desires of your client, etc