Difference between revisions of "Activity:EditOLEValue (Activity)"
| Line 36: | Line 36: | ||
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= | ||
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! |
