API CreateDownloadFile: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 64: | Řádek 64: | ||
| | | | ||
|} | |} | ||
==== Return ==== | |||
0 : OK | |||
100 : Item could not be created | |||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
DECLARE @return_value int | |||
Declare @fILE AS VARBINARY(MAX) | Declare @fILE AS VARBINARY(MAX) | ||
Select @fILE = CAST(bulkcolumn AS VARBINARY(MAX)) | Select @fILE = CAST(bulkcolumn AS VARBINARY(MAX)) | ||
| Řádek 74: | Řádek 79: | ||
SINGLE_BLOB ) AS x | SINGLE_BLOB ) AS x | ||
EXEC [API_CreateDownloadFile] @ValidFromDate = null ,@ValidToDate = null ,@GroupName= 'GroupName' ,@Title= 'Title' ,@Description= 'Description' ,@FileName= 'test.pdf' ,@SortIndex= 0 ,@FILEDATA= @fILE | EXEC @return_value = [API_CreateDownloadFile] @ValidFromDate = null ,@ValidToDate = null ,@GroupName= 'GroupName' ,@Title= 'Title' ,@Description= 'Description' ,@FileName= 'test.pdf' ,@SortIndex= 0 ,@FILEDATA= @fILE | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Aktuální verze z 21. 9. 2017, 10:55
Description
Method allows You to create new download file in system.
Exact name
API_CreateDownloadFile
Type
Standard executable stored procedure.
Specification
| Parameter | Data type | Value range | Description | Relation |
|---|---|---|---|---|
| @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 created
Example
DECLARE @return_value int
Declare @fILE AS VARBINARY(MAX)
Select @fILE = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK
'C:\test.pdf',
SINGLE_BLOB ) AS x
EXEC @return_value = [API_CreateDownloadFile] @ValidFromDate = null ,@ValidToDate = null ,@GroupName= 'GroupName' ,@Title= 'Title' ,@Description= 'Description' ,@FileName= 'test.pdf' ,@SortIndex= 0 ,@FILEDATA= @fILE
Notices
None.