API RemoveProductOEM: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method allows You to remove product replacement in system. ==== Exact name ==== <code>API_RemoveProductReplacements</code> ==== Typ…“) |
|||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádka 1: | Řádka 1: | ||
==== Description ==== | ==== Description ==== | ||
| − | Method allows You to remove product | + | Method allows You to remove OEM number for product. |
==== Exact name ==== | ==== Exact name ==== | ||
| − | <code> | + | <code>API_RemoveProductOEM</code> |
==== Type ==== | ==== Type ==== | ||
| Řádka 16: | Řádka 16: | ||
!Relation | !Relation | ||
|- | |- | ||
| − | |@ | + | |@GroupID |
|int | |int | ||
| | | | ||
| − | | | + | |GroupID |
| − | | | + | |API_GetProductGroups.ID |
| + | |- | ||
| + | |@OEM | ||
| + | |nvarchar(40) | ||
| + | | | ||
| + | |Original Equipment Manufacturer | ||
| + | | | ||
|} | |} | ||
| Řádka 30: | Řádka 36: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
DECLARE @return_value int | DECLARE @return_value int | ||
| − | EXEC @return_value = [ | + | EXEC @return_value = [API_RemoveProductOEM] |
| − | @ | + | @GroupID = 3, |
| + | @OEM = 'OE123' | ||
</syntaxhighlight> | </syntaxhighlight> | ||
==== Notices ==== | ==== Notices ==== | ||
None. | None. | ||
Aktuální verze z 12. 11. 2018, 17:06
Description
Method allows You to remove OEM number for product.
Exact name
API_RemoveProductOEM
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @GroupID | int | GroupID | API_GetProductGroups.ID | |
| @OEM | nvarchar(40) | Original Equipment Manufacturer |
Return
0 : OK 100 : Item does not exist
Example
DECLARE @return_value int
EXEC @return_value = [API_RemoveProductOEM]
@GroupID = 3,
@OEM = 'OE123'
Notices
None.
