See below, I get this message, so it seems, after a search like:
controller.find()
fieldname = 1;
controller.newRecord();
fieldname = 10+‘…’+20;
controller.search();
Your primary key sequence is out of sync with the table letters, this can happen when you add/replace a database and the servoy server doesn’t know about.
To fix open the letter table in the dataproviders dialog, open de properties of the primary key, open the tab ‘sequence’ and press ‘refresh’, ‘sync with db’ and ‘save’ button (between refresh and sync you will see the difference beteen the current seq and the needed sequence)
Hey Jan, this is strange since I didn’t replace/add or whatever on this database!!!
But ok I will sync it now…
Changed the pk in a Servoy Form then to one not YET used by sequence?
No Jan, non of them at all. Just a lot (a whole lot) of find/search and delete records…
And I just experienced the same problem. I changed the deletions into working with some (not a lot) transactions, committed and rolled back.
Could it have something to do with developer, switching modes inbetween or something like that?
It must a script then, if you do
order_id = 1000;//setting the pk (overruling the sequence)
so when there are 990 order with sequences from 1 to 990, when you create the 10th new order, you get this error.
OK, then I know the issue I think.
I had some broken searches due to testing. But, the script searches on ID so it is very well possible that something like what you described happened…