05-07-21 10:11:26 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Recipe_Upsert
Line : 37
Data source : ce2b1e979d1e4ac7a98e2057c504fbe1_0_10112321
Stack : Méthode AddSqlError (Log.AddSqlError), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 27
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Recipe_Upsert (cDAL.Recipe_Upsert), ligne 37
Procédure locale save (WIN_RECIPE.PROCEDURE.save), ligne 23
Clic sur btn_submit (WIN_RECIPE.btn_submit), ligne 1
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 'number_of_people', table 'vivacook.dbo.Recipe'; column does not allow nulls. INSERT fails.
SQL statement : 
set nocount on 

declare @id int = 0
exec dbo.Recipe_Upsert @id output, N'Tarte aux fraises', N'Entrez ici une description de votre recette.', Null, 1, N'Entrez ici vos notes internes.', 1, 1

set nocount off

select @id



05-07-21 10:25:12 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Recipe_Upsert
Line : 37
Data source : ac1c412a72894879b6722978f87cc240_0_10250964
Stack : Méthode AddSqlError (Log.AddSqlError), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 27
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Recipe_Upsert (cDAL.Recipe_Upsert), ligne 37
Procédure locale save (WIN_RECIPE.PROCEDURE.save), ligne 23
Clic sur btn_submit (WIN_RECIPE.btn_submit), ligne 1
Bouton gauche double-clic (WM_LBUTTONDBLCLK) sur tbl_recipe (WIN_MAIN.tbl_recipe), ligne 5
Error message : 23000	-	[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'description', table 'vivacook.dbo.Recipe'; column does not allow nulls. UPDATE fails.
SQL statement : 
set nocount on 

declare @id int = 3
exec dbo.Recipe_Upsert @id output, N'Spaghetti bolognaise', NULL, 4, 1, NULL, 1, 1

set nocount off

select @id



05-07-21 10:25:24 [NETBEE-03] [Admin] [] [C:\Mes Projets\Vivacook\Exe\Exécutable Windows 64 bits]
Form name : cDAL.Recipe_Upsert
Line : 37
Data source : 4a3b0e17da2049538910acf21fa3f20c_-65536_10252052
Stack : Méthode AddSqlError (Log.AddSqlError), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 27
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Recipe_Upsert (cDAL.Recipe_Upsert), ligne 37
Procédure locale save (WIN_RECIPE.PROCEDURE.save), ligne 23
Clic sur btn_submit (WIN_RECIPE.btn_submit), ligne 1
Bouton gauche double-clic (WM_LBUTTONDBLCLK) sur tbl_recipe (WIN_MAIN.tbl_recipe), ligne 5
Error message : 23000	-	[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'description', table 'vivacook.dbo.Recipe'; column does not allow nulls. UPDATE fails.
SQL statement : 
set nocount on 

declare @id int = 3
exec dbo.Recipe_Upsert @id output, N'Spaghetti bolognaise', NULL, 4, 1, NULL, 1, 1

set nocount off

select @id