API UpdateSelectedCategory - Historie editací

Chrzaszcz v 9. 11. 2018, 13:51

2018-11-09T13:51:28Z

← Starší verze		Verze z 9. 11. 2018, 13:51
Řádek 29:		Řádek 29:
	\|-		\|-
	\|@URL		\|@URL
	\|~~text~~		\|nvarchar(max)
	\|		\|
	\|URL		\|URL
Řádek 35:		Řádek 35:
	\|-		\|-
	\|@Image		\|@Image
	\|~~Image~~		\|varbinary(max)
	\|		\|
	\|Image		\|Image
Řádek 69:		Řádek 69:
	DECLARE @ID int		DECLARE @ID int
	DECLARE @Name nvarchar(255)		DECLARE @Name nvarchar(255)
	DECLARE @URL ~~text~~		DECLARE @URL nvarchar(max)
	DECLARE @Image ~~image~~		DECLARE @Image varbinary(max)
	DECLARE @ImageExt nvarchar(5)		DECLARE @ImageExt nvarchar(5)
	DECLARE @Language int		DECLARE @Language int

Chrzaszcz v 21. 9. 2017, 10:54

2017-09-21T10:54:04Z

← Starší verze		Verze z 21. 9. 2017, 10:54
Řádek 60:		Řádek 60:
	\|}		\|}

			==== 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 @Name nvarchar(255)		DECLARE @Name nvarchar(255)
Řádek 81:		Řádek 85:
	WHERE id = 3		WHERE id = 3

	EXECUTE [API_UpdateSelectedCategory]		EXECUTE @return_value = [API_UpdateSelectedCategory]
	@ID,		@ID,
	@Name,		@Name,

Chrzaszcz v 2. 8. 2017, 13:19

2017-08-02T13:19:01Z

← Starší verze		Verze z 2. 8. 2017, 13:19
Řádek 72:		Řádek 72:

	SELECT @ID = [ID],		SELECT @ID = [ID],
	@Name = [Name],		@Name = 'Name 2',
	@URL = [URL],		@URL = [URL],
	@Image = [Image],		@Image = [Image],

Chrzaszcz v 2. 8. 2017, 13:18

2017-08-02T13:18:27Z

← Starší verze		Verze z 2. 8. 2017, 13:18
Řádek 23:		Řádek 23:
	\|-		\|-
	\|@Name		\|@Name
	\|~~int~~		\|nvarchar(255)
	\|		\|
	\|Name		\|Name

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

2017-08-02T13:16:56Z

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

Nová stránka

==== Description ====
Method allows You to update selected category in system.

==== Exact name ====
<code>API_UpdateSelectedCategory</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@Name
|int
|
|Name
|
|-
|@URL
|text
|
|URL
|
|-
|@Image
|Image
|
|Image
|
|-
|@ImageExt
|nvarchar(5)
|
|Image ext
|
|-
|@Language
|int
|
|Language
cs=0; pl=1; en=2; de=3; sk=4; hu=5; ar=11; bg=17
|
|-
|@OrderNumber
|int
|
|Order number
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @Name nvarchar(255)
DECLARE @URL text
DECLARE @Image image
DECLARE @ImageExt nvarchar(5)
DECLARE @Language int
DECLARE @OrderNumber int

SELECT @ID = [ID],
@Name = [Name],
@URL = [URL],
@Image = [Image],
@ImageExt = [ImageExt],
@Language = [Language],
@OrderNumber = [OrderNumber]
FROM [API_GetSelectedCategories]
WHERE id = 3

EXECUTE [API_UpdateSelectedCategory]
@ID,
@Name,
@URL,
@Image,
@ImageExt,
@Language,
@OrderNumber

</syntaxhighlight>

==== Notices ====
None.

API UpdateSelectedCategory - Historie editací

Chrzaszcz v 9. 11. 2018, 13:51

Chrzaszcz v 21. 9. 2017, 10:54

Chrzaszcz v 2. 8. 2017, 13:19

Chrzaszcz v 2. 8. 2017, 13:18

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

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