Servoy number fields in Sybase iAnywhere 11

Classic Servoy
1

Hi all!

We noticed that since we have used Sybase iAnywhere 11 (before we was using version 10), NUMBER fields created in Servoy are being created as FLOAT in database. When we used Sybase iAnywhere 10, number fields was being created as DOUBLE in database.

Example:

[attachment=0]formFields.JPG[/attachment]

Price 1/price_1 field (NUMBER column created in Servoy “over” Sybase 10):

created in database as DOUBLE

grammage field (NUMBER column created in Servoy “over” Sybase 11):

created in database as FLOAT

In resources in Servoy:

[attachment=1]servoyDatabaseColumns.JPG[/attachment]

Due to this, we have this behaviour (as you can see, at form value showed are the same):

[attachment=2]databaseValues.JPG[/attachment]

Anybody has this “problem”/behaviour too? Is right new NUMBER columns are being created as FLOAT?

Best regards,

Gerardo.

formFields.JPG

servoyDatabaseColumns.JPG
servoyDatabaseColumns.JPG541×178 16.6 KB

databaseValues.JPG
databaseValues.JPG415×240 21 KB

2

This is a coincedence, I just posted the same thing!
We also have this “changing” behavior.
Our NUMBERs are created as DOUBLE in the database (sybase 11)

3

Hi.
Like Michel says now (5.1.0 Final) it is created as double in Sybase 11 again:

[attachment=1]Sybase_dabase_detail.PNG[/attachment]

I also see in the Database detail view in Servoy that the type is float…

[attachment=0]Servoy_dabase_detail.PNG[/attachment]

What would be the behaviour?

Servoy_dabase_detail.PNG
Servoy_dabase_detail.PNG651×261 14.3 KB

Sybase_dabase_detail.PNG
Sybase_dabase_detail.PNG960×268 17.4 KB

4

The behaviour (at this moment) is Number in javascript, double in the database.

But the big question is: is this behaviour going to change again? Because that is what happened recently, it changed from double to float to double again…

5

It would be interesting to know wether people of Servoy can confirm the changing behaviour or not…

6

When creating Number columns (which is float in java) we use the standard mapping defined by hibernate.
For sybase this maps to ''float" in the sql.

In sybase ianywhere <= 10 the created column is a double (jdbc type 8 )
In sybase ianywhere 11 this was changed to real (jdbc type 7)

We have overridden the mapping for sybase ianywhere 11 in Servoy 5.1 to ‘double precision’ to get back the same behaviour of older sybase versions. The created column is now a double (jdbc type 8 ) again

Rob

7

Rob,

Thanks for the explanation. Do you know what’s the precision of the float in java compared to the double in sybase?