Difference between revisions of "Activity:EditOLEValue (Activity)"
(→Arguments) |
|||
| 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 || Name of activity | + | | DataType|| DbType|| In || Name of activity and name of column |
|- align="left" | |- align="left" | ||
| DisplayName|| {{String_MSDN}}|| In || Name of activity | | DisplayName|| {{String_MSDN}}|| In || Name of activity | ||
|- align="left" | |- align="left" | ||
| − | | | + | | IsPrimary || {{Boolean_MSDN}}|| Out || 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 | ||
Revision as of 12:42, 5 March 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 and name of column |
| DisplayName | String | In | Name of activity |
| IsPrimary | 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! |
