API UpdateDownloadFile

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.