databaseManager.convertToDataset() creates wrong datatypes

Classic Servoy
1

Hello,

we have a problem in 3.5 with a method like that

var vDataset = databaseManager.convertToDataSet(pkValue);
controller.loadRecords(vDataset)

pkValue is an integer (primary key). This worked fine in Servoy < 3.5. 3.5 converts the pkValue to a double and the SQL engine complains about that.

A fix is to provide

databaseManager.convertToDataSet([pkValue]);

Or

databaseManager.convertToDataSet(pkValue + '');
2

Thanks for the tip Patrick - I have hit the same problem in 3.5 and was about to find a work around - you’ve saved me some time :D .

Anyone know if this is a bug or a permanent change?

3

Actually it was wrong usage from our side, because the parameter says pkArray or a String pk list… It does not say single integer pk.

4

Thanks for the clarification.