API UpdateOrders: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
Bez shrnutí editace
Bez shrnutí editace
Řádek 47: Řádek 47:


   
   
  set @ID = 15,
  set @ID = 15  
  set @ForeignOrderNumber = 'OR123456',
  set @ForeignOrderNumber = 'OR123456'
  set @SendDate = GETDATE()
  set @SendDate = GETDATE()



Verze z 6. 3. 2019, 15:10

Description

Method allows You to update order in system.

Exact name

API_UpdateOrders

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ID int Internal system id API_GetOrders.ID
@ForeignOrderNumber nvarchar(80) Foreign order number
@SendDate datetime Send date

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE @ID int
 DECLARE @ForeignOrderNumber nvarchar(80)
 DECLARE @SendDate datetime

 
 set @ID = 15 
 set @ForeignOrderNumber = 'OR123456'
 set @SendDate = GETDATE()

 
 EXECUTE @return_value = [API_UpdateDeliveryNote] 
   @ID
  ,@ForeignOrderNumber 
  ,@SendDate

Notices

None.