Difference between revisions of "Activity:EditOLEValue (Activity)"
(→Excel document - Update an existing row) |
|||
| Line 42: | Line 42: | ||
===Excel document - Update an existing row=== | ===Excel document - Update an existing row=== | ||
| + | {{Attention|The '''primary key''' argument needs to be checked at least for one column!}} | ||
[[File:UI_Activity_EditOLEValue_Excel_02.png]] | [[File:UI_Activity_EditOLEValue_Excel_02.png]] | ||
[[File:UI_Activity_EditOLEValue_Arguments_Excel_02.png]] | [[File:UI_Activity_EditOLEValue_Arguments_Excel_02.png]] | ||
Revision as of 15:29, 23 February 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 |
| DisplayName | String | In | Name of activity |
| Result | 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
Excel document - Update an existing row
 | The primary key argument needs to be checked at least for one column! |
