API UpdateArticle - Historie editací

Chrzaszcz v 9. 11. 2018, 11:19

2018-11-09T11:19:51Z

Chrzaszcz v 21. 9. 2017, 10:46

2017-09-21T10:46:54Z

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

2017-08-02T13:43:25Z

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

Nová stránka

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

==== Exact name ====
<code>API_UpdateArticle</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@Title
|nvarchar(50)
|
|Title
|
|-
|@HtmlText
|ntext
|
|Html text
|
|-
|@Language
|int
|
|Language.
cs=0; pl=1; en=2; de=3; sk=4; hu=5; ar=11; bg=17
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @Title nvarchar(50)
DECLARE @UrlName nvarchar(50)
DECLARE @HtmlText ntext
DECLARE @Language int

SELECT @ID = [ID],
@Title= 'Title 2',
@HtmlText = [HtmlText],
@Language = [Language]
FROM [API_GetArticles]
WHERE id = 3

EXECUTE [API_UpdateArticle]
@ID,
@Title,
@HtmlText,
@Language

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 29: / Řádka 29: @@
 |-
 |@HtmlText
-|ntext
+|nvarchar(max)
+|
 |Html text
@@ Řádka 52: / Řádka 52: @@
   DECLARE @Title nvarchar(50)
   DECLARE @UrlName nvarchar(50)
-  DECLARE @HtmlText ntext
+  DECLARE @HtmlText nvarchar(max)
   DECLARE @Language int

@@ Řádka 42: / Řádka 42: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @Title nvarchar(50)
@@ Řádka 58: / Řádka 62: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateArticle]
+  EXECUTE @return_value = [API_UpdateArticle]
    @ID,
    @Title,

API UpdateArticle - Historie editací

Chrzaszcz v 9. 11. 2018, 11:19

Chrzaszcz v 21. 9. 2017, 10:46

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

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