SQLDecimalPositions (Property)

Applies To:

Limit object

Description:

Specifies the number of digits to the right of decimal points in SQL numeric literal statements. The SQL statement uses this setting to determine which values to recognize. For example, if 0.12345678 is the filter value, the SQL statement writes “where column = 0.12346” (the rounded value). However, if you change the spinner to 8, SQL writes “where column = 0.12345678”.

Action:

Read-write, Boolean

Example:

This example shows how to set the SQL decimal places to 6.

ActiveDocument.Sections["SalesQuery"].Limits["Amount Sales"].SQLDecimalPositions = 6