UUID as PK issues

Classic Servoy
1

I have some strange issues with the uuid generator.
I had the UUID checkbox checked on the PK (text) column but decided later to uncheck it. So far so good.
Now when I create a new record I get a lot of errors about not being able to convert the UUID object. I even get a false on the saveData() function but when I check the failed records I see that the PK is not a string but a UUID object. I.e. no quotes around the value.
I double (and then some) checked that the table has no UUID checkbox checked (just sequence type uuid generator). I can reproduce this issue on 2 different machines.
Am I misunderstanding the UUID functionality or should I file a bugreport.

Also how can I convert a UUID Object into a string (for use in SQL)?

Servoy 4.1.4 -build 681
Java version 1.6.0_15 (Mac OS X 10.6.1)

2

If you use the UUID generator as primary key, you have to enable that checkbox… Internally, UUIDs are not kept as strings but UUID objects.

3

Ahh that explains things. Thank you Patrick.
Do you also know how (if possible) to convert such UUID object into a string so I could use a PK in some custom SQL?

4

I guess I am answering my own question here.
A simple cast to a String works.
It didn’t work before but that was when I had all those errors which really got Eclipse out of wack (no quit menu item, etc).

So all is good now I use the UUID checkbox.