API UpdateDownloadFile - Historie editací

Chrzaszcz v 21. 9. 2017, 10:57

2017-09-21T10:57:28Z

Chrzaszcz v 2. 8. 2017, 13:07

2017-08-02T13:07:43Z

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

2017-08-02T13:06:23Z

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

Nová stránka

==== Description ====
Method allows You to update download file in system.

==== Exact name ====
<code>API_UpdateDownloadFile</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@ValidFromDate
|datetime
|
|Valid from date
|
|-
|@ValidToDate
|datetime
|
|Valid to date
|
|-
|@GroupName
|nvarchar(200)
|
|Group name
|
|-
|@Title
|nvarchar(200)
|
|Title
|
|-
|@Description
|nvarchar(2000)
|
|Description
|
|-
|@FileName
|nvarchar(255)
|
|File name
|
|-
|@SortIndex
|int
|
|Sort index
|
|-
|@FILEDATA
|varbinary(max)
|
|File data
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @ValidFromDate datetime
DECLARE @ValidToDate datetime
DECLARE @GroupName nvarchar(200)
DECLARE @Title nvarchar(200)
DECLARE @Description nvarchar(2000)
DECLARE @FileName nvarchar(255)
DECLARE @SortIndex int
DECLARE @InsertedDate datetime
DECLARE @UpdatedDate datetime
DECLARE @FILEDATA varbinary(max)

SELECT @ID = [ID],
@ValidFromDate = [ValidFromDate],
@ValidToDate = [ValidToDate],
@GroupName = [GroupName],
@Title = [Title],
@Description = [Description],
@FileName = [FileName],
@SortIndex = [SortIndex],
@InsertedDate = [InsertedDate],
@UpdatedDate = [UpdatedDate],
@FILEDATA = [FILEDATA]
FROM [API_GetDownloadFiles]
WHERE id = 3

EXECUTE [API_UpdateDownloadFile]
@ID,
@ValidFromDate,
@ValidToDate,
@GroupName,
@Title,
@Description,
@FileName,
@SortIndex,
@InsertedDate,
@UpdatedDate,
@FILEDATA

</syntaxhighlight>

==== Notices ====
None.

@@ Řádka 71: / Řádka 71: @@
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
   DECLARE @ID int
   DECLARE @ValidFromDate datetime
@@ Řádka 100: / Řádka 104: @@
   WHERE  id = 3
-  EXECUTE [API_UpdateDownloadFile]
+  EXECUTE @return_value = [API_UpdateDownloadFile]
    @ID,
    @ValidFromDate,

@@ Řádka 90: / Řádka 90: @@
         @ValidToDate = [ValidToDate],
         @GroupName = [GroupName],
-        @Title = [Title],
+        @Title = 'Title 2',
         @Description = [Description],
         @FileName = [FileName],

API UpdateDownloadFile - Historie editací

Chrzaszcz v 21. 9. 2017, 10:57

Chrzaszcz v 2. 8. 2017, 13:07

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update download file in system. ==== Exact name ==== API_UpdateDownloadFile ==== Type ==== Standa…“

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