Subject RE: [firebird-support] unpredictable behavior after changing field size
Author Martin Dew
>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.



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/