ERROR:Insert or update on table"accnt" violates foreign key constrain

ERROR:Insert or update on table"accnt" violates foreign key
constraints "acct_to_curr_symbol"
DETAILS:KEY(accnt_curr_id)(-2)is not
present in the table "curr_symbol" ......solve The Problem..

Question Posted / kumarghosh.sougata

1 Answers
2587 Views
Wipro, I also Faced
E-Mail Answers

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_cur..

Answer / Kamal Kumar Maurya

To solve the issue, you need to ensure that the value of `accnt_curr_id` in the 'accnt' table is present in the 'curr_symbol' table. Here are a few possible solutions:

1. Verify the data you're trying to insert/update, and make sure it has a valid `accnt_curr_id` value that exists in the 'curr_symbol' table.
2. If the value is missing in the 'curr_symbol' table, add the missing value so it can be used in the 'accnt' table.
3. Modify the foreign key constraints by either changing the referenced column or its data type, or creating a new foreign key constraint with a different name and referencing a valid set of values.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer