API UpdateOrders - Historie editací

Chrzaszcz v 13. 5. 2021, 11:16

2021-05-13T11:16:52Z

2019-03-06T15:10:16Z

2019-03-06T15:09:17Z

2019-03-06T14:57:34Z

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

Nová stránka

@@ Řádka 52: / Řádka 52: @@
-  EXECUTE @return_value = [API_UpdateDeliveryNote]
+  EXECUTE @return_value = [API_UpdateOrders]
     @ID
    ,@ForeignOrderNumber

@@ Řádka 47: / Řádka 47: @@
-  set @ID = 15,
+  set @ID = 15
-  set @ForeignOrderNumber = 'OR123456',
+  set @ForeignOrderNumber = 'OR123456'
   set @SendDate = GETDATE()

← Starší verze		Verze z 6. 3. 2019, 15:09
Řádka 1:		Řádka 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.