Hi, I am getting familiar with OpenDB as I am considering using it in some project.
I opened Sample world DB in ObjectDB Explorer - and couldn't find my country, as it has invalid id ( ez instead of cz ). I changed the id of country to "cz". But when I try to find the country: SELECT c FROM Country c WHERE id = "cz" no results are returned. If i find it by name, I can see ID has changed to cz. However Country#ez is still displayed in the top.
When I save the changes and close and open it ObjectDB again id is back on ez. Changing county name works OK.
So the question is - is it possible to change field which is primary key? If so what am I doing wrong?