FMTBCD Fields problem

rbuser

Hi there!

I have found that there is a problem with TFMTBCD Fields as they are
generated for querys with dbExpress for fields containig numbers.
DisplayFormat does not work with such fields:

TppDBPipeline converts such fields to TppFields with DataType=dtString. This
way displayformats won't work, because dtString expects a "valid EditMask".
(So you can't format numbers :-(

I think that there should be a data type "dtBCD" !?

We have RB EE 6.02, Delphi EE 6.01

Olaf

digitalmetaphors

You may be able to do tha formatting on the fields by declaring your own
display format for the text control when it is generated. Here is an
example of creating custom formats.
http://www.digital-metaphors.com/tips/ReplaceDisplayFormats.zip


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Jim!

In further response to an older answer of your's:

Creating a custom format does not really solve the problem that RB (6.0.3)
doesn't recognise FMTBCD's as _numbers_.

When trying to apply a TppDBCalc to those fields, the calculation won't work
(i.e. the result is allways zero) because those fields are handled as
strings by RB. How should I handle those fields?

Regards,
Olaf