API UpdateOrders: Porovnání verzí
Z Podpora.nextis.cz
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádka 47: | Řádka 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, 12: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.
