API UpdateDownloadFile
Z Podpora.nextis.cz
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.