FIREBIRD: Can't add new record to database, sdbc error: violation of PRIMARY or UNIQUE KEY

edit

Kelsa this worked, thank you. The numbering sequence used by the primary key ID field had reset to a lower value in the range of previous records, using a duplicate primary ID number. This command reset that value to a number beyond the range previously used.

For reference to others using this information, you need to replace NUMBER with the numerical value you want to use as the new starting point for the primary key auto increment. For me it looked like this:

ALTER TABLE "MYTABLENAME" ALTER "ID" RESTART WITH 1500

Thank you for tip. In Mac I had the same problem and now I resolved, but it needed to save Base and to close and restart LibreOffice to take effect.