Decimals in database field - Forum - Community Groups - Progress Community

Decimals in database field

 Forum

Decimals in database field

This question is answered
Hi, Openedge 11.3 SP02. I have a temp-table with a field defined as decimal and format is '>>,>>9.999999'. In the database there's also a field defined as decimal and format is also '>>,>>9.999999'. Strange thing is that when I assign the field of the temp-table to the field in the database, only the two first numbers after the period are assigned. The value is also rounded to the value of two digits after the period. So 24.7752 becomes in the database 24.78 What am i doing wrong here ? kind regards Bart Syryn
Verified Answer
  • Hi,

    Yes, indeed that was the problem. How stupid of me.

    Thanks !

All Replies
  • Hi,

    Did you set the number of decimals on the database field? The default number of decimals for the database field is 2, you might need to increase it to 6. Note that this is not the same as setting the display format of the field. It is an additional property on the Data Dictionary for DECIMAL type fields.

    Regards,

    Mark Davies

  • Hi,

    Yes, indeed that was the problem. How stupid of me.

    Thanks !