DECIMAL / NUMBER problem MySQL

Classic Servoy
1

I am trying to sort out the following issue
Servoy 2.2.1 and a MySQL back end
A column in the MySQL table is DECIMAL (9,2)
In Servoy the Dataprovider showed NUMBER 2, this seems to be normal (but should be fixed)
The numbers in the database are stored in decimals but in the Servoy form they show as Integers even with format ##.00
When i tried to fix the problem by deleting the column in the dataprovider and recreating a new one with the same name as NUMBER 9,2 . Only the 9 showed up, and after restarting the developper the field showed empty on the form tough the data is still in tghe back end

I needed to rebuild the table in the database to have the data show up in the Servoy form again.

Quite frustrating,
Can someone explain what to do when one change columns in the back end
The expalnation in the manual are flimsy

2

Hi janber,

I came across a similar problem with PostgreSQL a long time ago. Can’t remember whether it was Decimal or Numeric I tried to use. My workaround :frowning: was to define a number in Servoy, then examine the database table to see what PostgreSQl type was created. Then I would use type from then on when creating tables outside Servoy.

It would be good if this is sorted out.