registry update problems (ondelete on update)

Question

registry update problems (ondelete on update)

Navigation

#1 by (0 votes)

0

Hello good afternoon to all, again consulting you the following: I have a table (citations) in which I need to store a series of IDs from other tables, including the idRegistration of a doctor, and the idRegistro of an official, the insert ok but when I try to do an edit, I get the following message:

in workbench, when creating the fk, there is an option that says ONUPDATE AND ONDELETE, leave them by default, but maybe I should make the change there? Has someone gone through the same situation?

Thank you very much for the comments, greetings to all ...

mysql c# mysql-workbench

asked by Nicolas Ezequiel Almonacid 31.07.2018 в 19:44

source

1 answer

How to store the sum of the values that are entered in mysql and php FILL Checkbox by default in JSF

score 0 · Answer 1

You are getting this error because you are trying to add or edit a row in the appointments table that does not have a valid value for the idRegistro field based on the values that are currently stored in the official table. Make sure that when you add or edit values, they are valid.