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...")
 
Line 18: Line 18:
 
! 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.

Revision as of 13:23, 30 January 2015

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+

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

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.

UI Activity Execute NonQuery OLEDB.PNG

See also