Difference between revisions of "Activity:EditOLEValue (Activity)"
(→Excel document - Update an existing row) |
|||
| Line 38: | Line 38: | ||
=Example= | =Example= | ||
===Excel document - Add a new row=== | ===Excel document - Add a new row=== | ||
| − | [[File:UI_Activity_EditOLEValue_Excel.png]] | + | [[File:UI_Activity_EditOLEValue_Excel.png|border|EditOLEValue]] |
| − | [[File:UI_Activity_EditOLEValue_Arguments_Excel.png]] | + | [[File:UI_Activity_EditOLEValue_Arguments_Excel.png|border|EditOLEValue Arguments]] |
===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!}} | {{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|border|EditOLEValue]] |
| − | [[File:UI_Activity_EditOLEValue_Arguments_Excel_02.png]] | + | [[File:UI_Activity_EditOLEValue_Arguments_Excel_02.png|border|EditOLEValue Arguments]] |
<headertabs /> | <headertabs /> | ||
Revision as of 15:48, 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! |
