Changes

Activity:ExecuteNonQueryStatement (Activity)

99 bytes added, 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 [[Activity:CreateOLEOracleScope (Activity)|CreateOLEOracleScope]] or [[Activity:CreateOLESQLScope (Activity)|CreateOLESQLScope]].

=Description=

{{ActivityInfoBox

| title = Execute a non Query statement

}}

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.

|}

===Usage===

This activity is used to execute a database statement.

=Example=

[[File:UI_Activity_Execute_NonQuery_OLEDB.PNG|x700px]]

==See also==

* [[Workflow Designer]]

* [[~~CreateOLEDBScope~~ Activity:CreateOLESQLScope (Activity)]]* [[Activity:CreateOLEOracleScope (Activity)]]

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

KNO

10,686

edits