Decimal computed column
- How-to
-
Mickey Hillel
- PowerBuilder
- Wednesday, 28 January 2026 07:13 PM UTC
Hi all,
Just wondering if anyone has any insights on how to correctly define a computed column on a datawindow (PB2025, SqlAnywhere 17).
We define a decimal as 0.00 in the computed column.
The column is created as decimal(0).
We change in edit source to decimal(2).
It's OK , till the next time any changes are made in the sql, when the computed column returns to decimal(0).
I found a bug that was opened way back when, 3205, Implicit Conversion of Decimal(2) to Decimal(0), that reported the exact same problem. Then the support said that they could not reproduce, but we've been experiencing this issue for many years.
Any help would be appreciated.
Mickey Hillel
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.