UUID as primary key problem

Classic Servoy
1

I seem to have a problem creating a foundset when I make the table’s primary key a UUID. Lets say I have a table with one row in it.

When I do this:

	var lofoundset = databaseManager.getFoundSet("cmhci","c6ctl");
	lofoundset.loadAllRecords();
	var lorecord=lofoundset.getRecord(1);

lofoundset maxRecordIndex = 0 and lorecord is null. When I change the PK to CHAR or INTEGER, it works fine, lofoundset maxRecordIndex = 1 and lorecord contains the row.

It seems to work this way with any table set up with a UUID PK. Nothing is loaded.

2

Can you create a case for this in our support system, with a little sample solution?

Paul