API UpdateProductReplacements: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „a“) |
|||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 1: | ||
| − | + | ==== Description ==== | |
| + | Method allows You to update product replacements in system. | ||
| + | |||
| + | ==== Exact name ==== | ||
| + | <code>API_UpdateProductReplacements</code> | ||
| + | |||
| + | ==== Type ==== | ||
| + | Standard executable stored procedure. | ||
| + | |||
| + | ==== Specification ==== | ||
| + | {| class="wikitable" | ||
| + | !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 ==== | ||
| + | <syntaxhighlight lang="sql"> | ||
| + | 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 | ||
| + | |||
| + | </syntaxhighlight> | ||
| + | |||
| + | ==== Notices ==== | ||
| + | None. | ||
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.
