Can not add or update to child row: a foreign key constraint fails MYSQL WITH C #

0

I am in this problem I was searching and so according to the error is that I do not have data in my table1 -> appointments to place it in my table 2 - >

I already made sure that the dating is the correct one

Open();
                string query = "CALL regisExpediente('@COD_SEG','@ID_CITA','@NRO_EXP','@TITULO','@ID_ABOG','@OBSER','@ID_INST','@MATERIA','@MOTIVO','@COMPRO','@ID_EST','@FE_INI','@FE_TER')";
                MySqlCommand cmd = new MySqlCommand(query,Connect());
                cmd.Parameters.AddWithValue("@COD_SEG",cod_seg);
                cmd.Parameters.AddWithValue("@ID_CITA",2);
                cmd.Parameters.AddWithValue("@NRO_EXP",nro_exp);
                cmd.Parameters.AddWithValue("@TITULO",titulo);
                cmd.Parameters.AddWithValue("@ID_ABOG",id_abog);
                cmd.Parameters.AddWithValue("@OBSER",obser);
                cmd.Parameters.AddWithValue("@ID_INST",id_inst);
                cmd.Parameters.AddWithValue("@MATERIA",materia);
                cmd.Parameters.AddWithValue("@MOTIVO",motivo);
                cmd.Parameters.AddWithValue("@COMPRO",compro);
                cmd.Parameters.AddWithValue("@ID_EST",id_est);
                cmd.Parameters.AddWithValue("@FE_INI",fe_ini);
                cmd.Parameters.AddWithValue("@FE_TER",fe_ter);
                int r = cmd.ExecuteNonQuery();
                Close();

THANKS

    
asked by Jeremy Kun 01.11.2018 в 22:44
source

0 answers