Helen

I need to have 18 digits (or more) to strore a numeric ID derived from
GUIDs. That's why I picked Numeric(18,0) since the Integer type in Firebird
holds no more than 10 digits. Delphi converts by itself the Numeric(18,0)
Firebird Field into TFmtBCDField on SQLDataSet and ClientDataSet
(dbExpress).

Regards,
Guillermo


"Helen Borrie" <helebor@...> escribi� en el mensaje
news:5.1.0.14.2.20020926110448.07458350@......

> At 05:20 PM 25-09-02 +0000, you wrote:
> >Thank you Thomas,
> >
> >Yes, by an email Martijn mentioned me that the driver should be ready
> >soon. My problem is that I'm kind of stucked in my project with this
> >Numeric(18,0)-FmtBCD issue, since all my Primary Keys in all tables
> >are of this type and with this problem. I had them DOUBLE PRECISION
> >before, but to avoid the precision or rounding problems I switched to
> >Numeric(18,0) which gets the GUID I generate from Delphi for every
> >record OID. Changing the OID type again would be painful...
>
> Guillermo,
> Why are you trying to make numeric(18,0) comply with BCD? With zero

scale,

> it is an integer (no precision for BCD to operate on).
>
> I'm curious. Maybe I'm just missing the point though.
>
> cheers,
> heLen
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>