ViewFoundSet specify numeric column length

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

ViewFoundSet specify numeric column length

Postby pitc » Thu Mar 04, 2021 1:29 am

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
Tom
prospect-saas.com
pitc
 
Posts: 115
Joined: Thu Nov 14, 2019 2:22 pm
Location: Ottawa, Ontario, Canada

Re: ViewFoundSet specify numeric column length

Postby swingman » Sat Mar 06, 2021 11:26 am

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...
Christian Batchelor
Certified Servoy Developer
Batchelor Associates Ltd, London, UK
http://www.batchelorassociates.co.uk

http://www.postgresql.org - The world's most advanced open source database.
User avatar
swingman
 
Posts: 1472
Joined: Wed Oct 01, 2003 10:20 am
Location: London

Re: ViewFoundSet specify numeric column length

Postby pitc » Mon Mar 08, 2021 10:46 pm

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
Tom
prospect-saas.com
pitc
 
Posts: 115
Joined: Thu Nov 14, 2019 2:22 pm
Location: Ottawa, Ontario, Canada


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 5 guests