BCD fields and FMTBCD fields
Posted: Mon 26 May 2014 20:41
Hi all,
So I was reading in the Web docs about the BCD field and FMTBCD Field and some things aren't exactly clear to me.
I have a Field defined in a Firebird database that is:
LTAVLRTOTAL DECIMAL(14,4) DEFAULT 0
and when I open the Fields Editor and add the fields in a TUniQuery, it shows up as FloatField if I have the EnableBCD = True, and if I have the EnableFMTBCD = True it shows up as a FMTBCDField.
As in the Docs at
http://www.devart.com/unidac/docs/index ... _types.htm
shows that
ftBCD -> DECIMAL(p, s) where (p < 15) and (s < 5)
ftFMTBCD -> DECIMAL(p, s) where (14 < p < 19) and(4 < s < 19)
Shouldn't the field showed up as a BCDField?
My doubt, Can I use the FMTBCDField without any problems? Willl this behaviour change in the next versions? is there any significant diference? (I believe not, but better ask now than being sorry later).
I am working with a lot a money operations and the BCDfield has always been the type that I used.
Using XE3 and Unidac 5.3.8 with Firebird 2.53
Just another thing, will the currency property at the field level make any diference?
Thanks
Andrew
So I was reading in the Web docs about the BCD field and FMTBCD Field and some things aren't exactly clear to me.
I have a Field defined in a Firebird database that is:
LTAVLRTOTAL DECIMAL(14,4) DEFAULT 0
and when I open the Fields Editor and add the fields in a TUniQuery, it shows up as FloatField if I have the EnableBCD = True, and if I have the EnableFMTBCD = True it shows up as a FMTBCDField.
As in the Docs at
http://www.devart.com/unidac/docs/index ... _types.htm
shows that
ftBCD -> DECIMAL(p, s) where (p < 15) and (s < 5)
ftFMTBCD -> DECIMAL(p, s) where (14 < p < 19) and(4 < s < 19)
Shouldn't the field showed up as a BCDField?
My doubt, Can I use the FMTBCDField without any problems? Willl this behaviour change in the next versions? is there any significant diference? (I believe not, but better ask now than being sorry later).
I am working with a lot a money operations and the BCDfield has always been the type that I used.
Using XE3 and Unidac 5.3.8 with Firebird 2.53
Just another thing, will the currency property at the field level make any diference?
Thanks
Andrew