For Exact Values I think I'm using numeric(18,4 ) for money also...

----- Original Message -----
From: "Gerard J.M.Houtenbos" <gh@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, October 24, 2002 3:51 PM
Subject: Re: [IBO] Monetary - Numeric(18,2) AsCurrency/AsExtended


> Martin,
>
> Why Numeric(18,2) and not Float?
>
> tia,
>
> Gerard
>
> On Wed, 23 Oct 2002 07:27:24 -0300, you wrote:
>
> >I'm using Numeric(18,2) to Monetary fields. To set/get these values in
> >code, what's the best alternative to avoid rounding problems?
> >
> >IB_Query.FieldByName('MonetaryField').AsCurrency or
> >IB_Query.FieldByName('MonetaryField').AsExtended ?
> >
> >Thanks.
> >
> >---------------------------
> >Martin D. Berezaga
> >mdberezaga@...
> >ICQ : 18537142
> >Porto Alegre - RS - Brasil
> >---------------------------
> >
> >_______________________________________________________________________
> >Yahoo! GeoCities
> >Tudo para criar o seu site: ferramentas fáceis de usar, espaço de sobra e acessórios.
> >http://br.geocities.yahoo.com/
> >
> >
> >___________________________________________________________________________
> >IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> > without the need for BDE, ODBC or any other layer.
> >___________________________________________________________________________
> >http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> >keyword-searchable FAQ, community code contributions and more !
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
>
> _________________________
>
> Gerard J.M. Houtenbos
> DoubleWood Software
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>