This may be due to the fact the when you changed the field size to 3 chars
(in a char field), then FB/IB pads the field to fit with trailing spaces. So
your 'CH' is actually 'CH ', and when you edit it, FB/IB is actaully getting
'CHS ', not 'CHS'....

-----Original Message-----
From: James [mailto:james_027@...]
Sent: 15 December 2003 16:11
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] unpredictable behavior after changing
field size


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



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/