I’m encountering this error, “Primary key for ‘fee’ table not unique.” Is there a technique for resetting primary keys?
A little background. I recently went through an issue on my server which, in the end, Servoy recommended reformatting the drive and as complete re-install. Something odd with PK values on new records. The issue is discussed at length at http://forum.servoy.com/viewtopic.php?t=6658.
Therefore, this is a new installation with a re-installed database from backup. The clean install on a clean machine has solved the JSP problem discussed in the earlier thread.
However now when working within the solution there is one action which automatically triggers a new record in the fee table. It’s when passing through that routine the error comes up.
What can be done? Much thanks,