01/02/2022 09:36:01 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Invoice_Upsert
Line : 55
Data source : e1f467627a534b5aab7b03e61088b04e_-65536_09360155
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 55
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 : 70010	-	Erreur (doublon) 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: 515
 
L'exécution de la requête suivante a échoué :
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 4
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220201',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220201',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 39, @id_company, 544, 894, NULL, NULL, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 47.169811, NULL, NULL, NULL, 50, NULL, 2, 1, 0, NULL, 11, 30, NULL , NULL
    
    set nocount off
    
    select @id
SQL statement : 
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 4
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220201',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220201',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 39, @id_company, 544, 894, NULL, NULL, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 47.169811, NULL, NULL, NULL, 50, NULL, 2, 1, 0, NULL, 11, 30, NULL , NULL
    
    set nocount off
    
    select @id



01/02/2022 09:37:36 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Invoice_Upsert
Line : 55
Data source : 703e9168f0814cc48213e250e01d204f_-65536_09373612
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 55
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 : 70010	-	Erreur (doublon) 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: 515
 
L'exécution de la requête suivante a échoué :
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 4
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220201',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220201',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 39, @id_company, 544, 894, NULL, NULL, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 41.322314, NULL, NULL, NULL, 50, NULL, 2, 1, 0, NULL, 11, 31, NULL , NULL
    
    set nocount off
    
    select @id
SQL statement : 
  set nocount ON
    
    DECLARE @id int = NULL
    DECLARE @id_company int = 4
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220201',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220201',103)
    
    exec @number = dbo.Invoice_GetNextNumber @id_company
     
    exec dbo.Invoice_Upsert @id output, 39, @id_company, 544, 894, NULL, NULL, @number , @invoice_date, @deadline_date, NULL , NULL, 1, 41.322314, NULL, NULL, NULL, 50, NULL, 2, 1, 0, NULL, 11, 31, NULL , NULL
    
    set nocount off
    
    select @id



