Last modified on 11 May 2020, at 15:26

EditOLEValue (Activity)

Revision as of 15:26, 11 May 2020 by JKN (Talk | contribs)

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 Column data type
DisplayName String In Name of activity and name of column
IsPrimary Boolean In 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.

Excel columns

Using Excel column names is possible, however, they cannot be addressed through their displayed name, but have to be referenced by F1, F2, F3...FN instead.

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