I have been using Base for a while, (years), with a rather simple database. I tried to create a new record on the form that I have been using without any changes since the beginning and I’m getting this error.
Error inserting the new record
firebird_sdbc error:
*violation of PRIMARY or UNIQUE KEY constraint “INTEG_3” on table “Library”
*Problematic key value is (“Barcode” = ‘0110501642778’)
caused by
‘isc_dsql_execute’
The barcodes are always 13 numbers and none of the formatting has been changed. Any ideas on how to fix this?
Windows 10 pro
LibreOffice version 7.5.2.2