API UpdateCustomMenuCategory: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method allows You to update custom menu category in system. ==== Exact name ==== <code>API_UpdateCustomMenuCategory</code> ==== Typ…“) |
|||
| Řádka 74: | Řádka 74: | ||
|} | |} | ||
| + | ==== Return ==== | ||
| + | 0 : OK | ||
| + | 100 : Item could not be updated | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| + | DECLARE @return_value int | ||
DECLARE @ID int | DECLARE @ID int | ||
DECLARE @ParentID int | DECLARE @ParentID int | ||
| Řádka 99: | Řádka 103: | ||
WHERE id = 3 | WHERE id = 3 | ||
| − | EXECUTE [API_UpdateCustomMenuCategory] | + | EXECUTE @return_value = [API_UpdateCustomMenuCategory] |
@ID, | @ID, | ||
@ParentID, | @ParentID, | ||
Aktuální verze z 20. 9. 2017, 15:14
Description
Method allows You to update custom menu category in system.
Exact name
API_UpdateCustomMenuCategory
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @ID | int | Internal system id | ||
| @ParentID | int | Parent category ID | ||
| @PageID | int | ID of article from articles list (see relation) | API_GetArticles.ID | |
| @Title | nvarchar(250) | Title | ||
| @Tooltip | nvarchar(250) | Tooltip | ||
| @Language | int | Language
cs=0; pl=1; en=2; de=3; sk=4; hu=5; nl=6; ru=7; et=8; lv=9; lt=10; ar=11; fr=12; it=13; pt=14; ro=15; es=16; tr=17; bg=17 |
||
| @URL | nvarchar(350) | URL | ||
| @OrderIndex | int | Order index | ||
| @BranchID | int | ID of branch from branch list (see relation) | API_GetBranches.ID |
Return
0 : OK 100 : Item could not be updated
Example
DECLARE @return_value int
DECLARE @ID int
DECLARE @ParentID int
DECLARE @PageID int
DECLARE @Title nvarchar(250)
DECLARE @Tooltip nvarchar(250)
DECLARE @Language int
DECLARE @URL nvarchar(350)
DECLARE @OrderIndex int
DECLARE @BranchID int
SELECT @ID = [ID],
@ParentID = [ParentID],
@PageID = [PageID],
@Title = 'Title 2',
@Tooltip = [Tooltip],
@Language = [Language],
@URL = [URL],
@OrderIndex = [OrderIndex],
@BranchID = [BranchID]
FROM [API_GetCustomMenuCategory]
WHERE id = 3
EXECUTE @return_value = [API_UpdateCustomMenuCategory]
@ID,
@ParentID,
@PageID,
@Title,
@Tooltip,
@Language,
@URL,
@OrderIndex,
@BranchID,
Notices
None.
