API UpdateDownloadFile

Z Podpora.nextis.cz
Přejít na: navigace, hledání

Description

Method allows You to update download file in system.

Exact name

API_UpdateDownloadFile

Type

Standard executable stored procedure.

Specification

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

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 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 2',
       @Description = [Description],
       @FileName = [FileName],
       @SortIndex = [SortIndex],
       @InsertedDate = [InsertedDate],
       @UpdatedDate = [UpdatedDate],
       @FILEDATA = [FILEDATA]
 FROM   [API_GetDownloadFiles] 
 WHERE  id = 3
 
 EXECUTE @return_value = [API_UpdateDownloadFile] 
  @ID, 
  @ValidFromDate,
  @ValidToDate,
  @GroupName,
  @Title,
  @Description,
  @FileName,
  @SortIndex,
  @InsertedDate,
  @UpdatedDate,
  @FILEDATA

Notices

None.