What happens if you edit that field and empty the inserted value and try
and save ?

If that works, then try and re- edit this value again to a 3 character
length value.

>>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



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/