Well, the statement work from isql :

insert into INTER_INTEROPERABLE values(
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');

Check out if all fields from the M$SQL source tables are same type as
FB target.

And if they are, check if none of the data varchar fields have some
spaces at the beginning ( space here > ' BACTOX 500MG PDR ET SOL INJ
IV IM Gé' will raise exception).

Regards,
Doru

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

>
> 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]
>