API UpdateOrders: Porovnání verzí

Z Podpora.nextis.cz
Skočit na navigaci Skočit na vyhledávání
Založena nová stránka s textem „fv“
 
Bez shrnutí editace
Řádek 1: Řádek 1:
fv
==== Description ====
Method allows You to update order in system.
 
==== Exact name ====
<code>API_UpdateOrders</code>
 
==== Type ====
Standard executable stored procedure.
 
==== Specification ====
{| class="wikitable"
!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 ====
<syntaxhighlight lang="sql">
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
 
</syntaxhighlight>
 
==== Notices ====
None.

Verze z 6. 3. 2019, 15:09

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.