API UpdateOrders: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „fv“ |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 2 mezilehlé verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 1: | ||
==== 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_UpdateOrders] | |||
@ID | |||
,@ForeignOrderNumber | |||
,@SendDate | |||
</syntaxhighlight> | |||
==== Notices ==== | |||
None. | |||
Aktuální verze z 13. 5. 2021, 11:16
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_UpdateOrders]
@ID
,@ForeignOrderNumber
,@SendDate
Notices
None.