Hello,

When I use database emulation, the Oracle fields that have a numeric data type (ex. Number (11,2)) are displayed by PlanetPress Design with 7 decimals.

For example:

Field VAL_TOT Number(11.2) in Oracle

becomes

ada66,

Sometimes, when PlanetPress converts a field value, it adds decimal values. What you can do is use a simple expression to display it in a custom data selection:

=curtostr(strtocur(field(VAL_TOT,1)))

The idea here is to first convert the field value to a currency, which only has two decimals, and then back to a string so that it can be displayed. This should get rid of the extra decimals.

As for BCD, I do not know what it is.

Regards,
Rapha

Thank you so much, that worked.