Change fields lenght

Wojtekm

Hello,

I need to change lenght "Name" field. Is there any tools to do it automatically in accurate tables - i can`t find that funtion in Dev Toolkit?


********
Wojtekm

modric

Ohhh AGAIN this Name field...

Yes, it`s too short, but you can`t that simple make it longer - it means changes in more than 60 tables, most reports and codeunits.

Common way to solve this situation - add your own "NameExt" ("Name 1" or as you like it) field with required length, where needed. I suggest Vendor/Client/Item names(descriptions), these are most commonly requested to be longer than default NAV Name field.

Alex_Chow

Or use Name 2.

idiot

Name 2 is not the way to go especially with double byte characters.
Sometimes end up breaking up (eg. company name) into 2 rows & is totally unacceptable.
Another possibility is even Name 2 is not long enough.
Solve this once & for all by increasing the length of Name & try not to get involve in Name 2, otherwise when Name 2 is not enough, be prepared for more headache & $ & time spent...

Wojtekm

Sometimes seemingly easy things becomes very difficult...

Alex_Chow

Wojtekm wrote:

Sometimes seemingly easy things becomes very difficult...

This has never been easy in a relational database environment...

David_Cox

Another Navision / Dynamics Non - Standard

In the GB database the Name is already Length 50 system wide, as is Name 2, Address and "Address 2", all the Customer, Vendor, Contact, Employee, Bill-to, Sell-to and Ship-to fields Match "Fantastic you say"!

Yes! but No!!, until you use any other databases and the Inter-Company module where they are all Length 30, !!OVERFLOW!!, but should MS not set the common fields to the largest localised database sizes?

Having just changed the 3 fields in all document tables on 11 localised databases to length 50, to match the GB Database for international inter-company transactions, I can say "it is not funny!"

Customer, Vendor, Sales Header, Purchase Header, Contact, Employee, Posted Sales, Posted Purchases, Warehouse, Inter-Company, and more!

At least the Format Address was ok!

David

David_Cox

"Name 2" is already part of the system, including format address codeunit, if you add another field to all the tables forms and the format address codeunit this is a lot more work, than changing the Name field length,which is also a lot of work, or using "Name 2", which you will need to add to the forms only.

David

kolaboy

HI,
I would advice you to create a new field for the name and give it the lenght you want to give it to. If you attempt to increase the already exsting lenght, you will run into problems, because you will have o do the same changes in diffiernt other place.
Thanks.