To give you the full story. dbExpress is suppose to be cross platform
compatible. Not
all numeric types are supported across all platforms, so when you use
Numeric it will
return the type as BCD or FmtBCD for compatibility across databases.

In D7, there is even a numeric mapping that will force all BCD to FmtBCD
to remove all
doubt. Hopefully the FB driver will be ready by Monday. It is real close.



Guillermo Najar-Arreola wrote:

>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/
>>
>>
>>
>>
>>
>
>
>
>
>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/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com



[Non-text portions of this message have been removed]