V tabuľke mám cudzí kľúč, kde je povolená hodnota null.
FHotDB.Table.Edit;
FHotDB.Table.FieldByName('FKBANKACCOUNTS').Value := null;
Result := FHotDB.PostRec;
Mesage text: violation of FOREIGN KEY constraint "FK_CAANALYTIC_BANK" on table "CAANALYTIC"
Foreign key reference target does not exist
-------------------------------------------
Command text: UPDATE CAANALYTIC
SET CODE = :NEW_CODE, FKBANKACCOUNTS = :NEW_FKBANKACCOUNTS
WHERE IDCAANALYTIC = :OLD_IDCAANALYTIC
Command parameters:
NEW_FKBANKACCOUNTS=0Ešte sa mi to nestalo. Odkiaľ sa tam berie tá nula? V nastaveniach FDConnection, FDTransaction a FDTable som nič nanašiel.
Pri insert pomocou FDQuery nie je žiaden problém.