20-07-21 10:14:13 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Event_Upsert
Line : 48
Data source : 7ffd6f3d9b9d4c22998cf92750f72e27_-65536_10134873
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 globale web_import_products (Vivacook.web_import_products), ligne 35
Méthode Start (Application.Start), ligne 36
Initialisation de Vivacook (), ligne 7
Error message : 23000	-	[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'event_date', table 'vivacook.dbo.Event'; column does not allow nulls. INSERT fails.
SQL statement : 
set nocount on 

declare @id int = 0
declare @date_event date = NULL
exec dbo.Event_Upsert @id output, N'Stage d''une journée Juprelle (option)', NULL, NULL, NULL, @date_event, N'09:00:00:00', N'16:00:00:00', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 14479

set nocount off

select @id



20-07-21 10:59:15 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Recipe_Product_Upsert
Line : 34
Data source : ce03fe9b74de440e8675d0fce13fd61a_0_10590964
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 Recipe_Product_Upsert (cDAL.Recipe_Product_Upsert), ligne 34
Bouton gauche enfoncé (WM_LBUTTONDOWN) de ZR_list (WIN_RECIPE.ZR_list), ligne 12
Clic sur btn_add_recipe (WIN_MAIN.btn_add_recipe), ligne 3
Error message : 23000	-	[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'id_recipe', table 'vivacook.dbo.Recipe_Product'; column does not allow nulls. INSERT fails.
SQL statement : 
set nocount on 

declare @id int = 0
exec dbo.Recipe_Product_Upsert @id output, NULL, 2, 1, 1

set nocount off

select @id



20-07-21 12:04:51 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Event_Upsert
Line : 48
Data source : e8824756c62742f495d368313e5d59c2_-65536_12044954
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 32
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 INSERT statement conflicted with the FOREIGN KEY constraint "FK_Event_user01". The conflict occurred in database "vivacook", table "dbo.User", column 'id'.
SQL statement : 
set nocount on 

declare @id int = 0
declare @date_event date = CONVERT(DATETIME,N'20210720',103)
exec dbo.Event_Upsert @id output, N'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:00:00:00', N'18:00:00:00', 50, 50, 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, 8, 2, 10, -1, 1, NULL

set nocount off

select @id



20-07-21 12:04:56 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Event_Upsert
Line : 48
Data source : d2c0241b166f47b180841d3f557cef46_-65536_12045428
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 32
Fermeture de WIN_EVENT (WIN_EVENT), 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 INSERT statement conflicted with the FOREIGN KEY constraint "FK_Event_user01". The conflict occurred in database "vivacook", table "dbo.User", column 'id'.
SQL statement : 
set nocount on 

declare @id int = 0
declare @date_event date = CONVERT(DATETIME,N'20210720',103)
exec dbo.Event_Upsert @id output, N'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:00:00:00', N'18:00:00:00', 50, 50, 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, 8, 2, 10, -1, 1, NULL

set nocount off

select @id



20-07-21 15:59:57 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Recipe_Product_Upsert
Line : 34
Data source : ca3ef5f5f98f4526b808c5e6211f2207_-65536_15595331
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 Recipe_Product_Upsert (cDAL.Recipe_Product_Upsert), ligne 34
Bouton gauche enfoncé (WM_LBUTTONDOWN) de ZR_list (WIN_RECIPE.ZR_list), ligne 12
Clic sur btn_add_recipe (WIN_MAIN.btn_add_recipe), ligne 5
Error message : 23000	-	[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'id_recipe', table 'vivacook.dbo.Recipe_Product'; column does not allow nulls. INSERT fails.
SQL statement : 
set nocount on 

declare @id int = 0
exec dbo.Recipe_Product_Upsert @id output, NULL, 27, 1, 1

set nocount off

select @id