API CreateDownloadFile - Historie editací

Chrzaszcz v 21. 9. 2017, 10:55

2017-09-21T10:55:57Z

← Starší verze		Verze z 21. 9. 2017, 10:55
Řá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>

Chrzaszcz v 31. 7. 2017, 12:15

2017-07-31T12:15:33Z

@@ Řádek 16: / Řádek 16: @@
 !Relation
 |-
-|@WorkshopID
+|@ValidFromDate
 |int
+|
-|ID of workshop from workshop list (see relation)
+|Sort index
-|API_GetWorkshops.ID
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
-EXEC [API_CreateDownloadFile] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
+Declare @fILE AS VARBINARY(MAX)
 </syntaxhighlight>
 ==== Notices ====
 None.

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

2017-07-31T12:05:16Z

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

Nová stránka

==== Description ====
Method allows You to create new download file in system.

==== Exact name ====
<code>API_CreateDownloadFile</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@WorkshopID
|int
|
|ID of workshop from workshop list (see relation)
|API_GetWorkshops.ID
|}

==== Example ====
<syntaxhighlight lang="sql">
EXEC [API_CreateDownloadFile] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
</syntaxhighlight>

==== Notices ====
None.

API CreateDownloadFile - Historie editací

Chrzaszcz v 21. 9. 2017, 10:55

Chrzaszcz v 31. 7. 2017, 12:15

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

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