27/01/2022 09:30:41 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Invoice_Upsert
Line : 53
Data source : 0a307aca9ca342819ee9d7ca251c461b_-65536_09304115
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Invoice_Upsert (cDal.Invoice_Upsert), ligne 53
Procédure locale save (WIN_INT_INVOICE.PROCEDURE.save), ligne 27
Clic sur BTN_Valider_Invoice (WIN_OFFER_FORM.BTN_Valider_Invoice), ligne 3
Procédure locale UpdateRow (WIN_INT_PURCHASE_ORDER_HOME.PROCEDURE.UpdateRow), ligne 62
Bouton gauche double-clic (WM_LBUTTONDBLCLK) sur tblH_Purchase_Order (WIN_INT_PURCHASE_ORDER_HOME.WIN_INT_PURCHASE_ORDER_HOME.tblH_Purchase_Order), ligne 14
Error message : 70015	-	Erreur (intégrité) de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e2f
Description: 
SQL State: 01000
SQL Error Number: 3621
 
Sous-erreur n°1
Description: 
SQL State: 23000
SQL Error Number: 547
 
L'exécution de la requête suivante a échoué :
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, NULL, 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 2000, NULL, NULL, NULL, 2000, NULL, 1, 1, 0, NULL, 6, 3
    
    set nocount off
    
    select @id
SQL statement : 
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, NULL, 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 2000, NULL, NULL, NULL, 2000, NULL, 1, 1, 0, NULL, 6, 3
    
    set nocount off
    
    select @id



27/01/2022 09:37:42 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Invoice_Upsert
Line : 53
Data source : 67e7c79da18e475f94842f6e7f4085bb_-65536_09373977
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Invoice_Upsert (cDal.Invoice_Upsert), ligne 53
Procédure locale save (WIN_INT_INVOICE.PROCEDURE.save), ligne 27
Clic sur BTN_Valider_Invoice (WIN_OFFER_FORM.BTN_Valider_Invoice), ligne 3
Procédure locale AddRow (WIN_INT_INVOICE_HOME.PROCEDURE.AddRow), ligne 4
Clic sur BTN_Add (WIN_INT_INVOICE_HOME.WIN_INT_INVOICE_HOME.BTN_Add), ligne 1
Error message : 70015	-	Erreur (intégrité) de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e2f
Description: 
SQL State: 01000
SQL Error Number: 3621
 
Sous-erreur n°1
Description: 
SQL State: 23000
SQL Error Number: 547
 
L'exécution de la requête suivante a échoué :
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, N'wtf', 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 2000, NULL, NULL, NULL, 2000, NULL, 1, 1, 0, NULL, 6, 3
    
    set nocount off
    
    select @id
SQL statement : 
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, N'wtf', 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 2000, NULL, NULL, NULL, 2000, NULL, 1, 1, 0, NULL, 6, 3
    
    set nocount off
    
    select @id



27/01/2022 15:36:42 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Invoice_Upsert
Line : 54
Data source : c8b5eb744bae4326ab9579f3361d17cd_-65536_15364192
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Invoice_Upsert (cDal.Invoice_Upsert), ligne 54
Procédure locale save (WIN_INT_INVOICE.PROCEDURE.save), ligne 32
Clic sur BTN_Valider_Invoice (WIN_OFFER_FORM.BTN_Valider_Invoice), ligne 3
Procédure locale AddRow (WIN_INT_INVOICE_HOME.PROCEDURE.AddRow), ligne 4
Clic sur BTN_Add (WIN_INT_INVOICE_HOME.WIN_INT_INVOICE_HOME.BTN_Add), ligne 1
Error message : 70015	-	Erreur (intégrité) de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e2f
Description: 
SQL State: 01000
SQL Error Number: 3621
 
Sous-erreur n°1
Description: 
SQL State: 23000
SQL Error Number: 547
 
L'exécution de la requête suivante a échoué :
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, NULL, 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 2000, NULL, NULL, NULL, 2000, NULL, 1, 1, 0, NULL, 6, 3, NULL
    
    set nocount off
    
    select @id
SQL statement : 
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, NULL, 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 2000, NULL, NULL, NULL, 2000, NULL, 1, 1, 0, NULL, 6, 3, NULL
    
    set nocount off
    
    select @id



27/01/2022 15:38:54 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Invoice_Upsert
Line : 54
Data source : e41ab890af23473c9a67967d83591f0a_-65536_15385436
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Invoice_Upsert (cDal.Invoice_Upsert), ligne 54
Procédure locale save (WIN_INT_INVOICE.PROCEDURE.save), ligne 32
Clic sur BTN_Valider_Invoice (WIN_OFFER_FORM.BTN_Valider_Invoice), ligne 3
Procédure locale AddRow (WIN_INT_INVOICE_HOME.PROCEDURE.AddRow), ligne 4
Clic sur BTN_Add (WIN_INT_INVOICE_HOME.WIN_INT_INVOICE_HOME.BTN_Add), ligne 1
Error message : 70015	-	Erreur (intégrité) de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e2f
Description: 
SQL State: 01000
SQL Error Number: 3621
 
Sous-erreur n°1
Description: 
SQL State: 23000
SQL Error Number: 547
 
L'exécution de la requête suivante a échoué :
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, NULL, 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 266, NULL, NULL, NULL, 266, NULL, 1, 1, 0, NULL, 6, 2, NULL
    
    set nocount off
    
    select @id
SQL statement : 
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, NULL, 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 266, NULL, NULL, NULL, 266, NULL, 1, 1, 0, NULL, 6, 2, NULL
    
    set nocount off
    
    select @id



27/01/2022 17:18:20 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Invoice_Upsert
Line : 54
Data source : ba9c1ef9ed404d11bda55eb84b4d038b_-65536_17182050
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Invoice_Upsert (cDal.Invoice_Upsert), ligne 54
Procédure locale save (WIN_INT_INVOICE.PROCEDURE.save), ligne 32
Clic sur BTN_Valider_Invoice (WIN_OFFER_FORM.BTN_Valider_Invoice), ligne 3
Procédure locale AddRow (WIN_INT_INVOICE_HOME.PROCEDURE.AddRow), ligne 4
Clic sur BTN_Add (WIN_INT_INVOICE_HOME.WIN_INT_INVOICE_HOME.BTN_Add), ligne 1
Error message : 73001	-	Erreur de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e07
Description: 
SQL State: 22018
SQL Error Number: 8114
 
L'exécution de la requête suivante a échoué :
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, NULL, 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 5203.5537, 20, NULL, NULL, 5696.3, NULL, 1, 0, 0, 10, 6, -1, NULL
    
    set nocount off
    
    select @id
SQL statement : 
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220127',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 131, @id_company, 540, 837, NULL, 2022, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 5203.5537, 20, NULL, NULL, 5696.3, NULL, 1, 0, 0, 10, 6, -1, NULL
    
    set nocount off
    
    select @id



