Chrzaszcz v 21. 9. 2017, 10:57

2017-09-21T10:57:28Z

← Starší verze		Verze z 21. 9. 2017, 10:57
Řádek 71:		Řádek 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
Řádek 100:		Řádek 104:
	WHERE id = 3		WHERE id = 3

	EXECUTE [API_UpdateDownloadFile]		EXECUTE @return_value = [API_UpdateDownloadFile]
	@ID,		@ID,
	@ValidFromDate,		@ValidFromDate,

Chrzaszcz v 2. 8. 2017, 13:07

2017-08-02T13:07:43Z

← Starší verze		Verze z 2. 8. 2017, 13:07
Řádek 90:		Řádek 90:
	@ValidToDate = [ValidToDate],		@ValidToDate = [ValidToDate],
	@GroupName = [GroupName],		@GroupName = [GroupName],
	@Title = [Title],		@Title = 'Title 2',
	@Description = [Description],		@Description = [Description],
	@FileName = [FileName],		@FileName = [FileName],

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update download file in system. ==== Exact name ==== `API_UpdateDownloadFile` ==== Type ==== Standa…“

2017-08-02T13:06:23Z

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…“

Nová stránka

==== Description ====
Method allows You to update download file in system.

==== Exact name ====
<code>API_UpdateDownloadFile</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!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
|
|}

==== Example ====
<syntaxhighlight lang="sql">
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],
@Description = [Description],
@FileName = [FileName],
@SortIndex = [SortIndex],
@InsertedDate = [InsertedDate],
@UpdatedDate = [UpdatedDate],
@FILEDATA = [FILEDATA]
FROM [API_GetDownloadFiles]
WHERE id = 3

EXECUTE [API_UpdateDownloadFile]
@ID,
@ValidFromDate,
@ValidToDate,
@GroupName,
@Title,
@Description,
@FileName,
@SortIndex,
@InsertedDate,
@UpdatedDate,
@FILEDATA

</syntaxhighlight>

==== Notices ====
None.

API UpdateDownloadFile - Historie editací

Chrzaszcz v 21. 9. 2017, 10:57

Chrzaszcz v 2. 8. 2017, 13:07

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update download file in system. ==== Exact name ==== API_UpdateDownloadFile ==== Type ==== Standa…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update download file in system. ==== Exact name ==== `API_UpdateDownloadFile` ==== Type ==== Standa…“