decimal wierdness

Classic Servoy
1

Servoy 2.2.5 Devel
Win XP
ASA iAnywhere 9.0.2

I have a form with a few number fields with decimals between 1 -6 places on it which has been fine until now. This morning I added a column to the table via dataproviders in Servoy. Now, all the number fields round to 2 decimal places.

There is no formatting property set for any form element
There are no scripts attached to any form element
I’ve looked at the data in the backend with Sybase Central, it’s fine.
I can display the field’s data as a label, or in a dialog, it’s fine

I’ve created a new form based on the same table. Same issue.
I’ve added new number fields to the new form. Same issue.

The only solution wide setting I can find is Locale in App Prefs. (English Australia) Number format is #.## I have never changed this.

Any ideas?

2

Hi Antonio,

This is very weird.
If you leave de format property of a field empty, it will always follow the settings in your prefs. So entering 1.2344 in a number field that has an empty format property , should display 1.23

So the behaviour you have right now, is actually the correct behaviour.
If you want to display variable decimals again, you should explicitly set the format property of your number field to “#.######”
BTW: if you want all your number fields to behave like this,
it’s of course better to set the format in your prefs to “#.######”

If anybody else has had the same experience as described in this thread,
please let us know.

Thanks.

3

OK, so the only weird part is that it wasn’t displaying just 2 decimal places initially, and now it is behaving.

I’m 100%+ sure that I was seeing up to 6 decimal places before I added the column (but this might be unrelated). I can’t think of anything else that I changed on the form or table.

4

v3.1
I seem to have a decimal problem as well

using sybase sql anywhere, field defined as numeric, 6 places

for field format, I tried both 0.00 and #.##

if I enter a decimal number, it won’t “stick”. It saves as integer

any suggestions appreciated

NOTE: this solution works fine in v2.7, but somehow broke when upgraded to v3

thanks
greg

PS
opened Servoy case (SVA:63931), can not enter decimal amounts. It has been fixed
Response: changes in 3.0 for other databases broke the non float types on sybase (non servoy created types)