API RemoveProductOEM: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „==== Description ==== Method allows You to remove product replacement in system. ==== Exact name ==== <code>API_RemoveProductReplacements</code> ==== Typ…“ |
Bez shrnutí editace |
||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 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 ==== | ||
| Řádek 16: | Řádek 16: | ||
!Relation | !Relation | ||
|- | |- | ||
|@ | |@GroupID | ||
|int | |int | ||
| | | | ||
| | |GroupID | ||
| | |API_GetProductGroups.ID | ||
|- | |||
|@OEM | |||
|nvarchar(40) | |||
| | |||
|Original Equipment Manufacturer | |||
| | |||
|} | |} | ||
| Řádek 30: | Řádek 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, 15: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.