Activity:ExecuteNonQueryStatement (Activity) - Revision history

KNO at 12:48, 23 February 2015

2015-02-23T12:48:18Z

KNO at 11:45, 23 February 2015

2015-02-23T11:45:48Z

KNO: /* See also */

2015-02-23T11:45:34Z

‎See also

KNO: moved ExecuteNonQueryStatement (Activity) to Activity:ExecuteNonQueryStatement (Activity): Text replacement - "(.*)$Activity$" to "Activity:$1(Activity)"

2015-02-23T11:07:31Z

moved ExecuteNonQueryStatement (Activity) to ExecuteNonQueryStatement (Activity): Text replacement - "(.*)$Activity$" to "Activity:$1(Activity)"

KNO at 08:55, 3 February 2015

2015-02-03T08:55:33Z

MHM at 13:23, 30 January 2015

2015-01-30T13:23:06Z

MHM: Created page with "{{ActivityInfoBox | title = Execute a non Query statement | name = ExecuteNonQueryStatement | image = 220px | imagecaption = Execute..."

2015-01-30T13:22:45Z

Created page with "{{ActivityInfoBox | title = Execute a non Query statement | name = ExecuteNonQueryStatement | image = 220px | imagecaption = Execute..."

New page

{{ActivityInfoBox
| title = Execute a non Query statement
| name = ExecuteNonQueryStatement
| image = [[File:UI_Activity_CreateOLESQLScope.png|220px]]
| imagecaption = ExecuteNonQueryStatement(Expanded)
| purpose = Execute database statements via OLE
| category = UBIK Data Exchange
| returns = the number of effected records
| version = 2.4.1+
}}

The ExecuteNonQueryStatement Activity provides the possibility to execute a database statement to a OLE compliant database. It is typically nested within a [[CreateOLEDBScope (Activity)|CreateOLEDBScope]] Activity.

==Arguments==

{| class="wikitable sortable" | width = "50%"
|-
! Argument!! Type !! Direction !! Purpose
|- align="left"
| Statement|| {{String_MSDN}}|| In || The statement to be executed
|- align="left"
| EffectedRecords|| {{Int32_MSDN}}|| Out || The number of effected records. If this number is less than 0, the statement execution failed.
|- align="left"
|}

==Usage==
This activity is used to execute a database statement.

[[File:UI_Activity_Execute_NonQuery_OLEDB.PNG|x700px]]

==See also==
* [[Workflow Designer]]
* [[CreateOLEDBScope (Activity)]]

[[Category:Workflows]] [[Category:Activities]] [[Category:Interfacing]] [[Category:OLE]]

← Older revision		Revision as of 08:55, 3 February 2015
Line 33:		Line 33:
	* [[CreateOLEDBScope (Activity)]]		* [[CreateOLEDBScope (Activity)]]

−	[[Category:~~Workflows~~]] [[Category:Activities~~]] [[Category:Interfacing]] [[Category:OLE~~]]	+	[[Category:OLE]]
		+	[[Category:Activities]]

@@ Line 1: / Line 1: @@
 {{ActivityInfoBox
 | title = Execute a non Query statement
@@ Line 10: / Line 13: @@
 }}
-The ExecuteNonQueryStatement Activity provides the possibility to execute a database statement to a OLE compliant database. It is typically nested within a [[Activity:CreateOLEDBScope (Activity)|CreateOLEDBScope]] Activity.
+===Arguments===
-−
 ==Arguments==
-−
 {| class="wikitable sortable" | width = "50%"
 |-
@@ Line 24: / Line 24: @@
 |}
-==Usage==
+===Usage===
 This activity is used to execute a database statement.
 [[File:UI_Activity_Execute_NonQuery_OLEDB.PNG|x700px]]
 ==See also==
 * [[Workflow Designer]]
-* [[Activity:CreateOLEDBScope (Activity)]]
+* [[Activity:CreateOLESQLScope (Activity)]]
 [[Category:OLE]]

← Older revision	Revision as of 11:07, 23 February 2015
(No difference)

@@ Line 18: / Line 18: @@
 ! Argument!! Type !! Direction !! Purpose
 |- align="left"
-| Statement|| {{String_MSDN}}||  In || The statement to be executed
+| Statement|| {{String_MSDN}}||  In || The statement to be executed.
 |- align="left"
 | EffectedRecords|| {{Int32_MSDN}}||  Out || The number of effected records. If this number is less than 0, the statement execution failed.