API UpdateUniversalPartsCategory - Historie editací

Chrzaszcz v 22. 9. 2017, 08:17

2017-09-22T08:17:00Z

Chrzaszcz v 2. 8. 2017, 12:58

2017-08-02T12:58:23Z

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update branch in system. ==== Exact name ==== `API_UpdateBranch` ==== Type ==== Standard executable…“

2017-08-02T12:57:27Z

Založena nová stránka s textem „==== Description ==== Method allows You to update branch in system. ==== Exact name ==== <code>API_UpdateBranch</code> ==== Type ==== Standard executable…“

Nová stránka

==== Description ====
Method allows You to update branch in system.

==== Exact name ====
<code>API_UpdateBranch</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
|
|-
|@Name
|nvarchar(250)
|
|Name
|
|-
|@Description
|nvarchar(800)
|
|Description
|
|-
|@SortIndex
|int
|
|Sort index
|
|-
|@IsRoot
|bit
|
|Is root
|
|-
|@IsTop
|bit
|
|Is top
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @ParentID int
DECLARE @Name nvarchar(250)
DECLARE @Description nvarchar(800)
DECLARE @SortIndex int
DECLARE @IsRoot bit
DECLARE @IsTop bit

SELECT @ID = [ID],
@ParentID = [ParentID],
@Name = 'Name 2',
@Description = [Description],
@SortIndex = [SortIndex],
@IsRoot = [IsRoot],
@IsTop = [IsTop]
FROM [API_GetUniversalPartsCategories]
WHERE id = 3

EXECUTE [API_UpdateUniversalPartsCategory]
@ID,
@ParentID,
@Name,
@Description,
@SortIndex,
@IsRoot,
@IsTop

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 59: / Řádka 59: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @ParentID int
@@ Řádka 80: / Řádka 84: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateUniversalPartsCategory]
+  EXECUTE @return_value = [API_UpdateUniversalPartsCategory]
    @ID,
    @ParentID,

@@ Řádka 1: / Řádka 1: @@
 ==== Description ====
-Method allows You to update branch in system.
+Method allows You to update universal parts category in system.
 ==== Exact name ====
-<code>API_UpdateBranch</code>
+<code>API_UpdateUniversalPartsCategory</code>
 ==== Type ====

API UpdateUniversalPartsCategory - Historie editací

Chrzaszcz v 22. 9. 2017, 08:17

Chrzaszcz v 2. 8. 2017, 12:58

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update branch in system. ==== Exact name ==== API_UpdateBranch ==== Type ==== Standard executable…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update branch in system. ==== Exact name ==== `API_UpdateBranch` ==== Type ==== Standard executable…“