Servoy Forum

In the IDE one can create a view and define the columns.
If there is a numeric column added the length of the column is 0.
Should I set this to non zero and to the expected length?
I tried to set length to 17,2 (two decimal places) but it reverts to 17.
The column that is coming from a query is an aggregate (ie sum) and the original table column is OpenEdge as 17,2
Tom
Servoy 2020.12.1.3623

Hi Tom,

I work with PostgreSQL and have found it easier to define numeric fields with a specific precision outside Servoy and then restart the developer to get the IDE to pick up the differences in the tables in Problems tab and Quick Fix to add the fields to Servoy. I don't know what other developers do, but it seems Servoy is abstracting numeric types a little bit too much.

From what you write, it sounds like this issue carrying over in the definition of views as well...

Nice tip.
I have raised a defect for this:
https://support.servoy.com/browse/SVY-15928?filter=-2
Hopefully this allows others to minimize defect removal time!
Tom