Changes
Created page with "{{ActivityInfoBox | title = Execute a non Query statement | name = ExecuteNonQueryStatement | image = [[File:UI_Activity_CreateOLESQLScope.png|220px]] | imagecaption = Execute..."
{{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]]
| 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]]
