API UpdateProductReplacements: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „a“ |
Bez shrnutí editace |
||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 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, 08: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.