Jump to: navigation, search

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


(Arguments)
 
(One intermediate revision by the same user not shown)
Line 35: Line 35:
 
===Usage===
 
===Usage===
 
This activity is used to edit a column value of a single OLE row.
 
This activity is used to edit a column value of a single OLE row.
 +
 +
{{Hint|If the data source is Excel 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=
 
=Example=
Line 52: Line 54:
 
* [[Activity:CreateOLETableScope (Activity)]]
 
* [[Activity:CreateOLETableScope (Activity)]]
  
[[Category:OLE]]
+
[[Category:OLE|EditOLEValue (Activity)]]

Latest revision as of 15:29, 11 May 2020

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.

IC Hint square.pngIf the data source is Excel 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