Increase field length of a standard table field

(0) Share

Report

Posted on by Sebastian Aurand

1,650

Hello,

I'm currently trying to extend the size of an existing standard table field (MainAccount.Name = str 60 to 120) via a table extension. As the property "size" is locked I tried to set a different extended data type. Unfortunatly is has no influence when entered "hardcoded" respectively no EDT is in the lookup:

5658.8750.Screenshot01.png

1440.0825.Screenshot-2.png

Is it possible to increase the size of string column? What is the correct way to do it?

I'm running 8.1. platform Version update 20.

Thanks in advance for any hint.

Sebastian

Categories:

Development / Customization / SDK

All responses (11)

Answers (1)

Dante Ramos 20 on at

Like (0)

Report

RE: Increase field length of a standard table field

Thank you so much, I tried in a different machine and worked like a charm, then tried in again in my machine but in a different model and worked, seems that there was something wrong with my model or maybe you were right and only needed one more build and sync :)

Thanks again. Best Regards.
nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Increase field length of a standard table field

Try to build your model one more time and do a full database sync.
Dante Ramos 20 on at

Like (0)

Report

RE: Increase field length of a standard table field

Thanks for the answer.

Yes, I tried in the EcoResProductCreation and currency forms, only gets 60 characters in the fields related to the Name EDT. Currency table uses Name directly and EcoResProductCreation uses EcoResProductName EDT.

In database the currency table's txt field and the EcoResProductTranslation table's name field has the size of 60.

And I forgot to answer your other question in my last comment, in AOT my extension is the only one made for Name EDT.
nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Increase field length of a standard table field

Did you really test it in the user interface, and try how many characters you can type in the field? Or did you just look at the properties of fields in Visual Studio?

Also, please check the field length in the SQL Server database, there you will see what the real length is.
Dante Ramos 20 on at

Like (0)

Report

RE: Increase field length of a standard table field

Thanks Nikolaos, your comments in this community forum saved me many times.

I tested it in a new EDT derived from Name but it's size is the name's size (60) not the size I put in my Name extension (200).

I even checked if it affected other EDTs derived from Name and tables that has fields that uses the Name EDT, but everywhere the string size is 60.

Thanks in advance.
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: Increase field length of a standard table field

Doesn't appear where? Did you test it? In AOT it only appears in your extension.
Dante Ramos 20 on at

Like (0)

Report

RE: Increase field length of a standard table field

Did changing the String Size property in the extension worked? I'm trying to do the same thing with the Name EDT (which doesn't derives from other EDT), but despite full synchronizing database and marking a full build of models, the new size doesn't appear further than my extension, I even tried creating a new EDT and set it as derived from Name.

Am I missing something?
Ali Zaidi 4,655 on at

Like (0)

Report

RE: [D365]: Increase field length of a standard table field

Create extension for AccountName. Usually two properties are extendable. 1- Label and then length. I test that you can increase the length in extension of Data type.
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: [D365]: Increase field length of a standard table field

It's not possible.

You must extend the underlying base EDT to achieve your goal.
Sebastian Aurand 1,650 on at

Like (0)

Report

RE: [D365]: Increase field length of a standard table field

So it is not possible to extend the field string size through changing the EDT on a table field via a table extension?