API CreateSelectedCategory - Historie editací

Chrzaszcz v 9. 11. 2018, 13:49

2018-11-09T13:49:23Z

Chrzaszcz v 21. 9. 2017, 10:51

2017-09-21T10:51:34Z

Chrzaszcz v 2. 8. 2017, 13:19

2017-08-02T13:19:50Z

Chrzaszcz v 31. 7. 2017, 12:18

2017-07-31T12:18:07Z

Chrzaszcz v 31. 7. 2017, 11:43

2017-07-31T11:43:32Z

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

2017-07-31T11:36:57Z

Založena nová stránka s textem „==== Description ==== Method allows You to create new selected category in system. ==== Exact name ==== <code>API_CreateSelectedCategory</code> ==== Type…“

Nová stránka

==== Description ====
Method allows You to create new selected category in system.

==== Exact name ====
<code>API_CreateSelectedCategory</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_CreateSelectedCategory] @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.

@@ Řádka 23: / Řádka 23: @@
 |-
 |@URL
-|text
+|nvarchar(max)
+|
 |URL
@@ Řádka 29: / Řádka 29: @@
 |-
 |@Image
-|Image
+|varbinary(max)
+|
 |Image

@@ Řádka 53: / Řádka 53: @@
+|
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
 Declare @img AS VARBINARY(MAX)
 Select @img = CAST(bulkcolumn AS VARBINARY(MAX))
@@ Řádka 63: / Řádka 68: @@
              SINGLE_BLOB ) AS x
-EXEC	[API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@Language= 0 ,@OrderNumber= 1
+ EXEC @return_value = [API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@Language= 0 ,@OrderNumber= 1
 </syntaxhighlight>
 ==== Notices ====
 None.

@@ Řádka 17: / Řádka 17: @@
 |-
 |@Name
-|int
+|nvarchar(255)
+|
 |Name

@@ Řádka 63: / Řádka 63: @@
              SINGLE_BLOB ) AS x
-EXEC	[API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@Lang = 0
+EXEC	[API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@Language= 0 ,@OrderNumber= 1
 </syntaxhighlight>
 ==== Notices ====
 None.

@@ Řádka 16: / Řádka 16: @@
 !Relation
 |-
-|@WorkshopID
+|@Name
 |int
+|
-|ID of workshop from workshop list (see relation)
+|Name
-|API_GetWorkshops.ID
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
-EXEC [API_CreateSelectedCategory] @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 @img AS VARBINARY(MAX)
 </syntaxhighlight>
 ==== Notices ====
 None.