API UpdateOrders: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 47: | Řádka 47: | ||
| − | set @ID = 15 | + | set @ID = 15 |
| − | set @ForeignOrderNumber = 'OR123456' | + | set @ForeignOrderNumber = 'OR123456' |
set @SendDate = GETDATE() | set @SendDate = GETDATE() | ||
Verze z 6. 3. 2019, 17:10
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.
