28/01/2022 16:15:57 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Invoice_Upsert
Line : 54
Data source : 4041fb9f96114fb8a1b89490a72ddfe3_0_16155703
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
Bouton gauche double-clic (WM_LBUTTONDBLCLK) sur tbl_Invoice (WIN_INT_INVOICE_HOME.WIN_INT_INVOICE_HOME.tbl_Invoice), ligne 13
Error message : 73001	-	Erreur de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e10
Description: 
SQL State: 42000
SQL Error Number: 201
 
L'exécution de la requête suivante a échoué :
  set nocount ON
    
    DECLARE @id int = 124
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220128',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220128',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, 1654.545455, NULL, NULL, NULL, 2002, NULL, 1, 1, 0, NULL, 6, 32, 125
    
    set nocount off
    
    select @id
SQL statement : 
  set nocount ON
    
    DECLARE @id int = 124
    DECLARE @id_company int = 3
    DECLARE @number int
    declare @invoice_date smalldatetime    = CONVERT(DATETIME,N'20220128',103)
    declare @deadline_date smalldatetime    = CONVERT(DATETIME,N'20220128',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, 1654.545455, NULL, NULL, NULL, 2002, NULL, 1, 1, 0, NULL, 6, 32, 125
    
    set nocount off
    
    select @id



