Helen, Nico,

>>I was expecting this error : I have a domain MYNUMBER NUMERIC(15,3). I
>>want to change it to NUMERIC(15,6). I got the following error :
>>"Conversion from base type DOUBLE PRECISION to BIGINT is not supported."
>>
>>But it seems I can change it to DOUBLE PRECISION. Would that be a good
>>idea for the underlying data ? I just need more decimals.

H> This is a tricky question. You have here a dialect 1 database.

Coundn't it be that it is a dialect 3 database, converted from
dialect 1? AFAIK numeric columns are not automatically converted from
floating point to bigint when you upgrade the dialect: you have to
recreate them and copy the data (or did it apply only for ODS9 ->
ODS10?).

H> Since you have been working with a double up to now, changing it to
H> "something else" probably won't make any difference if you don't upgrade
H> the database to dialect 3.

...and if what I written above is true, then it won't help either.

Ciao
--
Nando Dessena
mailto:nandod@...