API UpdateOrders - Historie editací

Chrzaszcz v 13. 5. 2021, 11:16

2021-05-13T11:16:52Z

← Starší verze		Verze z 13. 5. 2021, 11:16
Řádek 52:		Řádek 52:


	EXECUTE @return_value = [~~API_UpdateDeliveryNote~~]		EXECUTE @return_value = [API_UpdateOrders]
	@ID		@ID
	,@ForeignOrderNumber		,@ForeignOrderNumber

2019-03-06T15:10:16Z

2019-03-06T15:09:17Z

← Starší verze		Verze z 6. 3. 2019, 15:09
Řádek 1:		Řádek 1:
	fv		==== Description ====
			Method allows You to update order in system.

			==== Exact name ====
			<code>API_UpdateOrders</code>

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

			==== Specification ====
			{\| class="wikitable"
			!Parameter
			!Data type
			!Value range
			!Description
			!Relation
			\|-
			\|@ID
			\|int
			\|
			\|Internal system id
			\|API_GetOrders.ID
			\|-
			\|@ForeignOrderNumber
			\|nvarchar(80)
			\|
			\|Foreign order number
			\|
			\|-
			\|@SendDate
			\|datetime
			\|
			\|Send date
			\|
			\|}

			==== Return ====
			0 : OK
			100 : Item could not be updated

			==== Example ====
			<syntaxhighlight lang="sql">
			DECLARE @return_value int
			DECLARE @ID int
			DECLARE @ForeignOrderNumber nvarchar(80)
			DECLARE @SendDate datetime


			set @ID = 15,
			set @ForeignOrderNumber = 'OR123456',
			set @SendDate = GETDATE()


			EXECUTE @return_value = [API_UpdateDeliveryNote]
			@ID
			,@ForeignOrderNumber
			,@SendDate

			</syntaxhighlight>

			==== Notices ====
			None.

2019-03-06T14:57:34Z

Založena nová stránka s textem „fv“

Nová stránka