Overflow under type Conversion of text to text

kolaboykolaboy Member Posts: 446
Hi folks,
A client complained that whenever he/she tries to enter names on the Contact field on the Customer card, there is always an error saying:

"Overflow under type Conversion of text to text"

I decided to increase the Length of the Contact field from 30 to 100 in the Customer table, but i have another error saying: the name field cannot be copied to the search name field because the size is to small.
I also change the length of the name field on the Contact table but to no avail.
Have anyone encountered this Problem before. Can you please advise me as what to do now, because i don't know how to increase this size or avoid that error.
Please explain to me the Steps to take one by one. If there is any Code for the answer, I will be most grateful to see that code.
Thanks in Advance.

Comments

  • ara3nara3n Member Posts: 9,256
    We do not recommend users to increase field length. This is the exact reason.
    If you have to increase in one place, then you have to go throughout the system and increase it everywhere it is being referenced.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Alex_ChowAlex_Chow Member Posts: 5,063
    kolaboy wrote:
    Hi folks,
    A client complained that whenever he/she tries to enter names on the Contact field on the Customer card, there is always an error saying:

    "Overflow under type Conversion of text to text"

    I decided to increase the Length of the Contact field from 30 to 100 in the Customer table, but i have another error saying: the name field cannot be copied to the search name field because the size is to small.
    I also change the length of the name field on the Contact table but to no avail.
    Have anyone encountered this Problem before. Can you please advise me as what to do now, because i don't know how to increase this size or avoid that error.
    Please explain to me the Steps to take one by one. If there is any Code for the answer, I will be most grateful to see that code.
    Thanks in Advance.

    To address this problem, you'll need to undo all the field length changes you made to the standard tables. If you're not sure what the original field lengths are, then you'll need to reference the Cronus database
Sign In or Register to comment.