CREATE TABLE INTER_INTEROPERABLE (

INTER_SP_CODE INTEGER,

INTER_SP_NOM VARCHAR(36),

INTER_SP_NL VARCHAR(13),

INTER_PRE_CODE VARCHAR(50),

INTER_SP_CIPUCD VARCHAR(7),

INTER_SP_NOMLONG VARCHAR(255),

INTER_PRE_ADMIN VARCHAR(600),

INTER_PRE_ETAT_COMMER VARCHAR(2)

);





3704

BACTOX 500MG PDR ET SOL INJ IV IM Gé

6 018 205 9

3313797

9146484

BACTOX 500 MG, POUDRE ET SOLVANT POUR SOLUTION INJECTABLE (I.M., I.V.)

1 flacon(s) en verre - 1 ampoule(s) en verre de 5 ml

D

Query :insert into INTER_INTEROPERABLE values(?,?,?,?,?,?,?,?)

Arithmetic overflow or division by zero has occurred. Unable to execute
query

_____

De : firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] De la part de Doru Ilasi
Envoyé : mercredi 16 avril 2008 14:31
À : firebird-support@yahoogroups.com
Objet : [firebird-support] Re: Firebird error



Hi Mourad,
Can you post the query and the table metadata ? It would be easy for
us to help.
Regards,
Doru

--- In firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com, "HEDFI Mourad" <mourad@...>
wrote:

>
> I've a program that migrate data from MS SQLServer Database to 1.5

firebird

> database. For some records I've an error :
>
> Arithmetic overflow or division by zero has occurred. Unable to execute
> query, but I've not division and I've only one integer column, the

others

> are varchar.
>
> Does anyone have an idea about this problem to help me
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]