it points exactly to what I was thinking of:
- Code: Select all
com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -193: Primary key for table 'donations' is not unique : Primary key value ('1339')
I guess you're using Servoy sequence to insert your pk.
Servoy isn't in sync with the latest pk issued in you db, therefore it tries to insert a record with an already existing pk.
As I'm not familiar using Servoy sequences, I don't know the best way to solve the problem.
I know there's a button to upodate the sequence on the admin pages.