Subject | unpredictable behavior after changing field size |
---|---|
Author | James |
Post date | 2003-12-15T15:55:13Z |
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
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