Chrzaszcz v 20. 9. 2017, 14:14

2017-09-20T14:14:42Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update custom menu category in system. ==== Exact name ==== `API_UpdateCustomMenuCategory` ==== Typ…“

2017-08-02T13:51:09Z

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…“

Nová stránka

==== Description ====
Method allows You to update custom menu category in system.

==== Exact name ====
<code>API_UpdateCustomMenuCategory</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!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
|}

==== Example ====
<syntaxhighlight lang="sql">
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 [API_UpdateCustomMenuCategory]
@ID,
@ParentID,
@PageID,
@Title,
@Tooltip,
@Language,
@URL,
@OrderIndex,
@BranchID,

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 74: / Řádka 74: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @ParentID int
@@ Řádka 99: / Řádka 103: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateCustomMenuCategory]
+  EXECUTE @return_value = [API_UpdateCustomMenuCategory]
    @ID,
    @ParentID,

API UpdateCustomMenuCategory - Historie editací

Chrzaszcz v 20. 9. 2017, 14:14

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update custom menu category in system. ==== Exact name ==== API_UpdateCustomMenuCategory ==== Typ…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update custom menu category in system. ==== Exact name ==== `API_UpdateCustomMenuCategory` ==== Typ…“