Hi Helen,

Thanks for your reply. This database was originally a dialect 1 database under IB 5.6. I did a backup under IB 5.6 and a restore under FB 1.5. After the restore, I changed the dialect to dialect 3 with GFIX.

Nico


At 11:20 AM 9/04/2004 +0000, you wrote:

>Hi,
>
>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.

This is a tricky question. You have here a dialect 1 database. We can
discern that because Dialect 1 integers don't have enough precision to
support NUMERIC(15,2) so your domain is stored a double. Dialect 3 *can*
support a true NUMERIC(15,6).

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

/heLen