Decimal datatypes are supported in the DataWindow, but in previous releases of PowerBuilder, decimal values were converted to doubles in DataWindow expressions. PowerBuilder 10.5 adds support for decimal values in DataWindow expressions and new DataWindow expression functions to support decimal values. You can also use decimal values as retrieval arguments. In PowerBuilder 10.5, the decimal datatype supports up to 28 digits.
The following arithmetic operators now return a decimal value if both operands have a datatype of decimal:
Operator |
Meaning |
Example |
|---|---|---|
+ |
Addition |
Subtotal + Tax |
- |
Subtraction |
Price - Discount |
* |
Multiplication |
Quantity*Price |
/ |
Division |
Discount/Price |
If either operand is not a decimal, the returned value is converted to a double datatype. The exponentiation operator (^) continues to return a double.
Relational operators that operate on numeric values (including =, >, <, <>, >=, and <=) can take decimal operands. The precision of the decimal operand is maintained in comparisons.
The following functions return a decimal datatype if their arguments are decimals: Sum, CumulativeSum, Avg, Median, First, Last, Max, Min, Large, Small, Var, VarP, Mod, Mode, Abs, Case, If.
The following new functions return a decimal result instead of a double: CrosstabAvgDec, CrosstabMaxDec, CrosstabMinDec, and CrosstabSumDec.
The new Dec function
converts a string to a decimal. You can also append the letter D
in upper- or lowercase to identify a number as a decimal constant
in a DataWindow expression. For example, 2.0d and 123.456789012345678901D are
treated as decimals.
Decimal and Decimal array have been added to the list of types in the Specify Retrieval Arguments dialog box.
For descriptions of the new functions, see the DataWindow Reference or the online Help.
