API UpdateSelectedCategory - Historie editací

Chrzaszcz v 9. 11. 2018, 13:51

2018-11-09T13:51:28Z

Chrzaszcz v 21. 9. 2017, 10:54

2017-09-21T10:54:04Z

Chrzaszcz v 2. 8. 2017, 13:19

2017-08-02T13:19:01Z

Chrzaszcz v 2. 8. 2017, 13:18

2017-08-02T13:18:27Z

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

2017-08-02T13:16:56Z

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

Nová stránka

==== Description ====
Method allows You to update selected category in system.

==== Exact name ====
<code>API_UpdateSelectedCategory</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@Name
|int
|
|Name
|
|-
|@URL
|text
|
|URL
|
|-
|@Image
|Image
|
|Image
|
|-
|@ImageExt
|nvarchar(5)
|
|Image ext
|
|-
|@Language
|int
|
|Language
cs=0; pl=1; en=2; de=3; sk=4; hu=5; ar=11; bg=17
|
|-
|@OrderNumber
|int
|
|Order number
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @Name nvarchar(255)
DECLARE @URL text
DECLARE @Image image
DECLARE @ImageExt nvarchar(5)
DECLARE @Language int
DECLARE @OrderNumber int

SELECT @ID = [ID],
@Name = [Name],
@URL = [URL],
@Image = [Image],
@ImageExt = [ImageExt],
@Language = [Language],
@OrderNumber = [OrderNumber]
FROM [API_GetSelectedCategories]
WHERE id = 3

EXECUTE [API_UpdateSelectedCategory]
@ID,
@Name,
@URL,
@Image,
@ImageExt,
@Language,
@OrderNumber

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 23: / Řádka 23: @@
 |-
 |@Name
-|int
+|nvarchar(255)
+|
 |Name

@@ Řádka 29: / Řádka 29: @@
 |-
 |@URL
-|text
+|nvarchar(max)
+|
 |URL
@@ Řádka 35: / Řádka 35: @@
 |-
 |@Image
-|Image
+|varbinary(max)
+|
 |Image
@@ Řádka 69: / Řádka 69: @@
   DECLARE @ID int
   DECLARE @Name nvarchar(255)
-  DECLARE @URL text
+  DECLARE @URL nvarchar(max)
-  DECLARE @Image image
+  DECLARE @Image varbinary(max)
   DECLARE @ImageExt nvarchar(5)
   DECLARE @Language int

@@ Řádka 60: / Řádka 60: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @Name nvarchar(255)
@@ Řádka 81: / Řádka 85: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateSelectedCategory]
+  EXECUTE @return_value = [API_UpdateSelectedCategory]
    @ID,
    @Name,