API UpdateOrders: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádek 47: | Řádek 47: | ||
set @ID = 15 | set @ID = 15 | ||
set @ForeignOrderNumber = 'OR123456' | set @ForeignOrderNumber = 'OR123456' | ||
set @SendDate = GETDATE() | set @SendDate = GETDATE() | ||
EXECUTE @return_value = [ | EXECUTE @return_value = [API_UpdateOrders] | ||
@ID | @ID | ||
,@ForeignOrderNumber | ,@ForeignOrderNumber | ||
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.