API UpdateDownloadFile: Porovnání verzí
Z Podpora.nextis.cz
(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…“) |
|||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádka 71: | Řádka 71: | ||
|} | |} | ||
| + | ==== Return ==== | ||
| + | 0 : OK | ||
| + | 100 : Item could not be updated | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| + | DECLARE @return_value int | ||
DECLARE @ID int | DECLARE @ID int | ||
DECLARE @ValidFromDate datetime | DECLARE @ValidFromDate datetime | ||
| Řádka 90: | Řádka 94: | ||
@ValidToDate = [ValidToDate], | @ValidToDate = [ValidToDate], | ||
@GroupName = [GroupName], | @GroupName = [GroupName], | ||
| − | @Title = | + | @Title = 'Title 2', |
@Description = [Description], | @Description = [Description], | ||
@FileName = [FileName], | @FileName = [FileName], | ||
| Řádka 100: | Řádka 104: | ||
WHERE id = 3 | WHERE id = 3 | ||
| − | EXECUTE [API_UpdateDownloadFile] | + | EXECUTE @return_value = [API_UpdateDownloadFile] |
@ID, | @ID, | ||
@ValidFromDate, | @ValidFromDate, | ||
Aktuální verze z 21. 9. 2017, 11:57
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.
