Martin Dew wrote:

>>Good day.
>>
>>I think a need a lesson from the experts here. Recently I have change a
>>
>>
>field from a char(2) to char(3). And when Iam doing some edits upon
>posting it Iam getting a "Arithmetic overflow or division by zero >has
>accured. arithmetic exception, numeric overflow, or string truncation."
>
>
>>While the new value Iam posting is only 3 chars I don't why this error
>>
>>
>is coming out. If what I have done is very wrong, may I know why is this
>happening? I didn't have the same experience before in other >databases.
>
>
>>Regards
>>
>>James
>>
>>
>
>Have you tried doing this with an insert statement ? Does it still
>happen ? If not then I would suggest you check your code and make sure
>that no components have this field listed in them with old size of 2
>still assigned.
>
>
>

Hi

Yes I have done this with insert statement and it works fine. In my
application I have make sure that there is no components that list this
field with the old size of 2. Even in IBexpert when I try to make the
edit ... example from CH to CSH this error occur.

James