NAV 2013 R2 - Why can't this URL field be longer than 20?

MarcusRB

Hello,

I've created a new table and in this table there's a field called "Link", it's of type Text with a length of 50 and it's ExtendedDataType is set to URL.

When I try to insert anything above 20 characters I get the following error:


Is there some implicit restriction in NAV that doesn't allow more characters, or is there some property that I just can't seem to find that will allow more characters?

Best regards
Marcus

MarcusRB

It seems that because the Link field is a part of the primary key, that it's not allowed it's full length.... I just tried creating an ID field and using that as the primary key instead of the Link combined with Machine and Rolecenter, and I was able to enter a link that was longer than 20 characters.

Does anyone know why that is?

logger

Hi @MarcusRB ,
Have you already checked:
1/ OnValidation trigger?
2/ This page field properties?

MarcusRB

logger wrote: »

Hi @MarcusRB ,
Have you already checked:
1/ OnValidation trigger?
2/ This page field properties?

Since I've created the table and pages, there's no code.

MarcusRB

It seems that because the Link field is a part of the primary key, that it's not allowed it's full length.... I just tried creating an ID field and using that as the primary key instead of the Link combined with Machine and Rolecenter, and I was able to enter a link that was longer than 20 characters.

Does anyone know why that is?

Slawek_Guzek

Perhaps you have a relation on the field to another table. It happens if you copy field definittion from another table and modify it later, forgotting to amend TableRelation property