Jump to: navigation, search

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


(Arguments)
Line 22: Line 22:
 
| DataRow|| {{DataRow_MSDN}}|| In|| Row to be edited
 
| DataRow|| {{DataRow_MSDN}}|| In|| Row to be edited
 
|- align="left"
 
|- align="left"
| DataType|| DbType|| In || Name of activity
+
| DataType|| DbType|| In || Name of activity and name of column
 
|- align="left"
 
|- align="left"
 
| DisplayName|| {{String_MSDN}}|| In || Name of activity
 
| DisplayName|| {{String_MSDN}}|| In || Name of activity
 
|- align="left"
 
|- align="left"
| Result|| {{Boolean_MSDN}}|| Out || Set to '''true''' for primary key columns; otherwise '''false'''
+
| IsPrimary || {{Boolean_MSDN}}|| Out || Set to '''true''' for primary key columns; otherwise '''false'''
 
|- align="left"
 
|- align="left"
 
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed
 
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed

Revision as of 12:42, 5 March 2015

The EditOLEValue activity provides access to a single column value of a row within an OLE compliant data source. It is typically nested within a CreateOLERow or EditOLERow.

[edit]

Description

Edit OLE Value
Name EditOLEValue
Purpose Edit a column value of a single OLE row
Category UBIK Data Exchange
Returns True if successful
Version 2.4.1+

Arguments

Argument Type Direction Purpose
CreatedValue Object Out not used
DataRow DataRow In Row to be edited
DataType DbType In Name of activity and name of column
DisplayName String In Name of activity
IsPrimary Boolean Out Set to true for primary key columns; otherwise false
Result Boolean Out True if successful, false if failed
Value String In Column value (required)

Usage

This activity is used to edit a column value of a single OLE row.

Example

Excel document - Add a new row

EditOLEValue EditOLEValue Arguments

Excel document - Update an existing row

IC Attention.pngThe primary key argument needs to be checked at least for one column!

EditOLEValue EditOLEValue Arguments

See also