Disappearing numbers

Classic Servoy
1

We have the following situation on hand. In a MySQL db we have two columns Price 1 and Price 2, there are values in these fields for sure. Not only do we know it but it is all so visible through MySQL admin and Cocoa MySQL. But in Servoy old layouts and new layouts do not show these values.

Does anyone have a clue what might be the problem and more important what could be the solution?

We use:
Version 3.5 rc3-build 508
Java version 1.5.0_07-87 (Mac OS X)
All the machines with the same config (iMac G4, iMac G5, Desktop G5 and MacBook Pro) give this result.

Afbeelding 1.png
Afbeelding 1.png805×379 63.9 KB

Afbeelding 3.png
Afbeelding 3.png679×336 40.3 KB

2

remon kortman:
In a MySQL db we have two columns Price 1 and Price 2, there are values in these fields for sure.

Is this an imported solution or did you maybe swap the database? My guess is that either the column names in the solution don’t match those of the database (‘price2’ vs. ‘price_2’ or ‘Price2’ or somesuch) or the type in the database doesn’t match that of the solution. The Servoy type should be ‘NUMBER’.

3

Hi Sandor,

No it is not an imported solution fields are prijs and prijs2 through CocoaMySQL the field type is decimal and length is 12,2. Through Servoy’s data provider they have the same name but type is then number and the strange thing is that the length is 2?! :?:

It has been working for over two years so what could have happened?
Is there a solution to solve this problem?

4

The problem is solved thanks to Robert :idea: from Roclasi. The problem was related to the drivers. We were using a jdbc driver for MySQL version 5.0.4 with MySQL version 4.1.22. An earlier version 3.1.14 so as version 5.0.6 did not have this problem.

Problem solved - case closed!