Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Problem with BCD Fields

edited May 2002 in General
Hi Jim!

I have noticed that RB6.03 doesn't recognise FMTBCD fields. It simply
handles them as string fields, this is bad because you can't do calculations
with tppDBCalc fields with them...

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







Comments

  • edited May 2002
    We'll continue researching this issue. For now, if RB sees them as strings,
    so you can use a TppVariable and code the OnCalc event handler to perform
    the calculation. Set the variable's Datatype to double and perform the
    calculation like: Value := Value + DataPipeline['myFieldName']; You can
    use the display formatting on the Variable if its datatype is set correctly
    form the drop down box. Thankyou for your patience.

    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited May 2002
    Ok - this works. But it doesn't if I have end user reports (without RAP).
    There I'm a little bit stuck now...

    Regards,
    Olaf


This discussion has been closed.