26/07/2021 11:27:59 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Event_Upsert
Line : 48
Data source : 5830239e5d754e6cad67903db0dbc902_0_11275669
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 20
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Event_Upsert (cDAL.Event_Upsert), ligne 48
Procédure locale save (WIN_EVENT.PROCEDURE.save), ligne 36
Clic sur btn_submit (WIN_EVENT.btn_submit), ligne 1
Clic sur btn_add_event (WIN_MAIN.btn_add_event), ligne 3
Error message : 23000	-	[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Event_recipe01". The conflict occurred in database "vivacook", table "dbo.Recipe", column 'id'.
SQL statement : 
set nocount on 

declare @id int = 260
declare @date_event date = CONVERT(DATETIME,N'20220310',103)
exec dbo.Event_Upsert @id output, N'Evenement test', N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
', 10, 1, @date_event, N'10:30:00:00', N'12:30:00:00', 25, 0, N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
', NULL, 4, 11, -1, 6, 1, NULL

set nocount off

select @id