API CreateDownloadFile: Porovnání verzí
Z Podpora.nextis.cz
(Založena nová stránka s textem „==== Description ==== Method allows You to create new download file in system. ==== Exact name ==== <code>API_CreateDownloadFile</code> ==== Type ==== St…“) |
|||
| Řádka 16: | Řádka 16: | ||
!Relation | !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 | |int | ||
| | | | ||
| − | | | + | |Sort index |
| − | | | + | | |
| + | |- | ||
| + | |@FILEDATA | ||
| + | |varbinary(max) | ||
| + | | | ||
| + | |File data | ||
| + | | | ||
|} | |} | ||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
| − | + | Declare @fILE AS VARBINARY(MAX) | |
| + | Select @fILE = CAST(bulkcolumn AS VARBINARY(MAX)) | ||
| + | FROM OPENROWSET( | ||
| + | BULK | ||
| + | 'C:\test.pdf', | ||
| + | SINGLE_BLOB ) AS x | ||
| + | |||
| + | EXEC [API_CreateDownloadFile] @ValidFromDate = null ,@ValidToDate = null ,@GroupName= 'GroupName' ,@Title= 'Title' ,@Description= 'Description' ,@FileName= 'test.pdf' ,@SortIndex= 0 ,@FILEDATA= @fILE | ||
| + | |||
</syntaxhighlight> | </syntaxhighlight> | ||
==== Notices ==== | ==== Notices ==== | ||
None. | None. | ||
Verze z 31. 7. 2017, 13:15
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 |
Example
Declare @fILE AS VARBINARY(MAX)
Select @fILE = CAST(bulkcolumn AS VARBINARY(MAX))
FROM OPENROWSET(
BULK
'C:\test.pdf',
SINGLE_BLOB ) AS x
EXEC [API_CreateDownloadFile] @ValidFromDate = null ,@ValidToDate = null ,@GroupName= 'GroupName' ,@Title= 'Title' ,@Description= 'Description' ,@FileName= 'test.pdf' ,@SortIndex= 0 ,@FILEDATA= @fILE
Notices
None.
