At 02:37 PM 22-08-01 +0000, you wrote:

>Hello,
>
>I have a Dialect 1 database with the following Domain Definition for
>Currency:
>CREATE DOMAIN CURRENCY_D AS DOUBLE PRECISION;
>
>In IBO 4.2.Eb it is not possible to have this and
>TIB_Column.IsCurrency=True, because this is only for Numeric
>Datatypes and scale<>0 as I read from Code.
>
>Is this right? Any Workaround for me?

Unless you bring those columns over as computed - CAST(aColumn as NUMERIC(18,2)) AS MyMoneyColumn, or similar (not very useful) - you are stuck with float. Double and float are not recommended for money columns because of precision problems.

rgds
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________