I have the following problem. I am trying to convert my BDE application to
a firebird application. So I created equal tables on the firebird side. I
then send record for record over which then throws an error on the 182'th
record. The recors is still inserted but it still pops the following error
message :
"
'The SQL : INSERT INTO COUNTRY (Field1,Field2,Field3,Field4,Field5,Field6)
VALUES(?,?,?,?,?,?) ; SQL Error : Arithmetic exception , numeric overflow
or string truncation. Error Code: -802. Arithmetic overflow or division by
zero has occured.'
"

Now I tried changing the connection protocol , deleting that specific
record , my fields are all VARCHAR except for the primary key which is an
integer. All the VARCHAR fields are either the same size or bigger. The BDE
table contains no row where all the fields are NULL. Even if I run up to
the 182'th record just before the insert and inspect the fields sent
through they all contain values and it always throws the exception on the
182'th record. Does anybody have more of a clue what is going on.