preciseDecimal

Owned by David Russo
Last updated: Oct 29, 2024
1 min read

This setting was added in Profound.js version 7.14.0

Enabling this setting can potentially break applications that were not coded for precise decimal.

Support for precise decimal values in SQL results sets is limited to the following drivers:

  • IBMi

  • odbc

  • mssql

With odbc and mssql drivers, values with more than 15 digits can still lose precision, due to limitations in 3rd party packages.

This setting controls automatic definition of precise decimal values. Valid values are:

  • false (default): Never automatically define precise decimal values.

  • true: Always automatically define precise decimal values.

  • number: Number of digits. Decimal values with this number or more digits will be automatically defined as precise decimal.

This setting affects the following portions of the framework:

  • Strongly typed field definitions that are produced automatically by the framework from external definitions. For example, external RLA DB files, printer files, and Rich Display Files.

  • Rich Display File bound fields with Decimal type.

  • SQL result sets containing decimal values, where supported.

  • Low Code RDF, Module, and Profound API CRUD generation over DB tables containing decimal columns. The setting is used to auto-populate the Precise decimal checkbox on input/output parameter settings.

  • Low Code Module input/output parameters defined with IBM i / RPG lengths.