Difference between revisions of "Activity:EditOLEValue (Activity)"
(Created page with "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 [[Activity:CreateOLERow (Activ...") |
|||
| (8 intermediate revisions by 2 users not shown) | |||
| 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 || | + | | DataType|| DbType|| In || Column data type |
|- align="left" | |- align="left" | ||
| − | | DisplayName|| {{String_MSDN}}|| In || Name of activity | + | | DisplayName|| {{String_MSDN}}|| In || Name of activity and name of column |
|- align="left" | |- align="left" | ||
| − | | | + | | IsPrimary || {{Boolean_MSDN}}|| In || 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 | ||
| 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= | ||
===Excel document - Add a new row=== | ===Excel document - Add a new row=== | ||
| − | [[File: | + | [[File:UI_Activity_EditOLEValue_Excel.png|border|EditOLEValue]] |
| − | [[File: | + | [[File:UI_Activity_EditOLEValue_Arguments_Excel.png|border|EditOLEValue Arguments]] |
===Excel document - Update an existing row=== | ===Excel document - Update an existing row=== | ||
| − | [[File: | + | {{Attention|The '''primary key''' argument needs to be checked at least for one column!}} |
| − | [[File: | + | [[File:UI_Activity_EditOLEValue_Excel_02.png|border|EditOLEValue]] |
| + | [[File:UI_Activity_EditOLEValue_Arguments_Excel_02.png|border|EditOLEValue Arguments]] | ||
<headertabs /> | <headertabs /> | ||
| Line 51: | 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.
 | 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
Excel document - Add a new row
Excel document - Update an existing row
 | The primary key argument needs to be checked at least for one column! |
