PostgreSQL Servoy Datatypes

Classic Servoy
1

Have a feeling this is bug but wanted some other thoughts before making a case as I am brand new with Postgres.

If I create a new field in Servoy and give it the datatype of “numeric” and set a length of “0” or any other value it appears to save it. However if I add another field and save it then changes the length to 4. If I look in PGAdmin it shows the datatype as “real”. If I change it to numeric with a length of 0 in PGAdmin then Servoy shows the length as 65535 which I assume is the max that type of field can hold.

I assume that Servoy setting it as “real” and the length not saving correct is a bug but since I am new to all of this I didn’t know if had overlooked something.

Which leads me to another question…

I am working on a stock market app for a client. I need the values to be exact so if the value is “0.9801” it is currently showing in the form as “0.98”. Even though the length is 0 in PGAdmin and 65535 in Servoy. In PGAdmin it shows the value of the field as “0.9801”. I have no mask or formats set.

Thanks,
Bryant

2

Bryant, did you resolve this issue?

If it was a bug, did you report it? Release 5.2.2 addressed similar (and maybe related) issue:
[fix] 316304 Field of type Number does not result in double precision field in database.

See the post here: http://forum.servoy.com/viewtopic.php?f=16&t=14960#p79922

JC

3

Thanks for pointing that out as I missed that yesterday. I will upgrade this week and give it a shot but it seems to be the same issue so hopefully it is fixed.