Decimal Fields Again

  • supernova42

    (@supernova42)


    8 years, 2 months ago

    Hi Roland
    I want to change the decimal accuracy of my decimal fields and you advised that I can change the precision of the decimal field by editing the field datatype in the database directly using phpMyAdmin. This post discusses setting up the datatype: https://xnau.com/setting-up-a-currency-or-other-decimal-type-field/

    The default accuracy was 14,4 for the fields in question. I changed these to 10,6 which would allow values of 180.123456. For some reason, after I change the fields using phpMyAdmin the fields later change back to their initial value of 14,4. So what am I doing wrong and how do I permanently change the accuracy of these fields?
    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    8 years, 2 months ago

    Thanks for pointing this out, I plan to have a way to prevent the customized datatype from getting changed…this will happen if other parameters of the field definition are changed: it will revert back to the default value. It shouldn’t do that.

    Thread Starter supernova42

    (@supernova42)

    8 years, 2 months ago

    Does the latest Participants Database upgrade resolve this problem Roland.
    i.e.
    customized datatype parameters won’t be reverted when the field definition is saved #1717
    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Decimal Fields Again’ is closed to new replies.