How to adjust length and scale of decimal datatype?

How-to(s), solutions to common problems, pearls of wisdom

av686165
Posts: 9
Joined: Fri Feb 14, 2020 5:53 am

How to adjust length and scale of decimal datatype?

Postby av686165 » Tue Mar 17, 2020 12:39 pm

How to adjust length and scale of decimal datatype? By default, the decimal datatype is adjusted as (12,2), but I want it as 12,4 or 12,5

bartonv
Posts: 145
Joined: Wed May 03, 2017 12:10 pm

Re: How to adjust length and scale of decimal datatype?

Postby bartonv » Fri Mar 20, 2020 3:08 pm

Hi there,
the length and scale can be changed:
  • by editing the metadata (CloverDX Designer > Outline pane > Metadata),
  • in the Metadata Wizard, click on the desired decimal-type field,
  • locate the 'Length' and 'Scale' properties in the grid on the right,
  • change the values as desired, click on the 'Finish' button and save the changes.
More information can be found in our documentation.
Kind regards,
---
Vladimir Barton
CloverCARE Support
CloverDX

Visit us online at http://www.cloverdx.com


cron