API UpdateOrders: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „fv“) |
|||
| (Nejsou zobrazeny 2 mezilehlé verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 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, 13: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.
