API UpdateProductReplacements: Porovnání verzí
Z Podpora.nextis.cz
| Řádka 38: | Řádka 38: | ||
0 : OK | 0 : OK | ||
100 : Item could not be updated | 100 : Item could not be updated | ||
| − | + | 200 : GroupID does not exist | |
| + | 250 : ReplacementID does not exist | ||
| + | 300 : Item does not exist | ||
| + | 500 : GroupID is not product (Level 1) | ||
| + | 550 : ReplacementID is not product (Level 1) | ||
| + | |||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
Aktuální verze z 29. 9. 2017, 09:19
Description
Method allows You to update product replacements in system.
Exact name
API_UpdateProductReplacements
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @ID | int | Internal system id | API_GetProductReplacements.ID | |
| @GroupID | int | Group ID | API_GetProductGroups.ID | |
| @ReplacementID | int | Replacement ID | API_GetProductGroups.ID |
Return
0 : OK 100 : Item could not be updated 200 : GroupID does not exist 250 : ReplacementID does not exist 300 : Item does not exist 500 : GroupID is not product (Level 1) 550 : ReplacementID is not product (Level 1)
Example
DECLARE @return_value int
DECLARE @ID int
DECLARE @GroupID int
DECLARE @ReplacementID int
SELECT @ID = [ID],
@GroupID = [GroupID],
@ReplacementID = 8
FROM [API_GetProductReplacements]
WHERE id = 3
EXECUTE @return_value = [API_UpdateProductReplacements]
@ID,
@GroupID,
@ReplacementID
Notices
None.
