Jump to: navigation, search

Difference between revisions of "Activity:ExecuteNonQueryStatement (Activity)"


(Created page with "{{ActivityInfoBox | title = Execute a non Query statement | name = ExecuteNonQueryStatement | image = 220px | imagecaption = Execute...")
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
The ExecuteNonQueryStatement activity provides the possibility to execute a database statement to an OLE compliant database. It is typically nested within [[Activity:CreateOLEOracleScope (Activity)|CreateOLEOracleScope]] or [[Activity:CreateOLESQLScope (Activity)|CreateOLESQLScope]].
 +
 +
=Description=
 
{{ActivityInfoBox
 
{{ActivityInfoBox
 
| title = Execute a non Query statement
 
| 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 [[CreateOLEDBScope (Activity)|CreateOLEDBScope]] Activity.
+
===Arguments===
 
+
==Arguments==
+
 
+
 
{| class="wikitable sortable" | width = "50%"
 
{| class="wikitable sortable" | width = "50%"
 
|-
 
|-
 
! Argument!! Type !! Direction !! Purpose
 
! Argument!! Type !! Direction !! Purpose
 
|- align="left"
 
|- align="left"
| Statement|| {{String_MSDN}}||  In || The statement to be executed
+
| Statement|| {{String_MSDN}}||  In || The statement to be executed.
 
|- align="left"
 
|- align="left"
 
| EffectedRecords|| {{Int32_MSDN}}||  Out || The number of effected records. If this number is less than 0, the statement execution failed.
 
| EffectedRecords|| {{Int32_MSDN}}||  Out || The number of effected records. If this number is less than 0, the statement execution failed.
Line 24: Line 24:
 
|}
 
|}
  
==Usage==
+
===Usage===
 
This activity is used to execute a database statement.
 
This activity is used to execute a database statement.
  
 +
=Example=
 
[[File:UI_Activity_Execute_NonQuery_OLEDB.PNG|x700px]]
 
[[File:UI_Activity_Execute_NonQuery_OLEDB.PNG|x700px]]
 +
 +
<headertabs />
  
 
==See also==
 
==See also==
 
* [[Workflow Designer]]
 
* [[Workflow Designer]]
* [[CreateOLEDBScope (Activity)]]
+
* [[Activity:CreateOLESQLScope (Activity)]]
 +
* [[Activity:CreateOLEOracleScope (Activity)]]
  
[[Category:Workflows]] [[Category:Activities]] [[Category:Interfacing]] [[Category:OLE]]
+
[[Category:OLE]]

Latest revision as of 12:48, 23 February 2015

The ExecuteNonQueryStatement activity provides the possibility to execute a database statement to an OLE compliant database. It is typically nested within CreateOLEOracleScope or CreateOLESQLScope.

[edit]

Description

Execute a non Query statement
Name ExecuteNonQueryStatement
Purpose Execute database statements via OLE
Category UBIK Data Exchange
Returns the number of effected records
Version 2.4.1+

Arguments

Argument Type Direction Purpose
Statement String In The statement to be executed.
EffectedRecords Integer Out The number of effected records. If this number is less than 0, the statement execution failed.

Usage

This activity is used to execute a database statement.

Example

UI Activity Execute NonQuery OLEDB.PNG

See also