[firebird-support] Help with error message (Firebird 3)

['Paul Coshott' p...@coshott.com [firebird-support]]

Hi All,

 

I am getting an error during an sql insert, done with Firedac within a
delphi vcl app.

 

The error is:

 

[FireDAC][Phys][FB]violation of PRIMARY or UNIQUE KEY constraint "INTEG_50"
on table "ROSTER"

Problematic key value is ("ROSTERID" = 19)

 

The field ROSTERID is the primary key field.

 

There is no record with the key value of 19 (the highest is 11) and there
are only 4 records in the table.

The sql insert is:

 

INSERT INTO ROSTER

    (ROSTERID, COMPANYID, DESCRIPTION, START_DATE, END_DATE, STATUS,
CREATOR, SEND_PUB_NOTIFICATION)

VALUES (

    19,

    1,

    'Roster Starting 19-02-2019 to 25-02-2019',

    '2020-01-26',

    '2020-02-01',

    'D',

    1,

    False)

 

Can anyone tell me what the error means and what could be the cause.

 

Thanks,

Paul