Activity:EditOLEValue (Activity) - Revision history

JKN at 15:29, 11 May 2020

2020-05-11T15:29:22Z

JKN at 15:26, 11 May 2020

2020-05-11T15:26:04Z

KNO: /* Arguments */

2015-03-05T12:43:42Z

‎Arguments

KNO: /* Arguments */

2015-03-05T12:43:09Z

‎Arguments

KNO: /* Arguments */

2015-03-05T12:42:45Z

‎Arguments

KNO: /* Arguments */

2015-03-05T12:42:26Z

‎Arguments

KNO at 15:48, 23 February 2015

2015-02-23T15:48:40Z

KNO: /* Excel document - Update an existing row */

2015-02-23T15:29:31Z

‎Excel document - Update an existing row

KNO at 15:28, 23 February 2015

2015-02-23T15:28:50Z

KNO: 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..."

2015-02-23T15:28:35Z

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..."

New page

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 (Activity)|CreateOLERow]] or [[Activity:EditOLERow (Activity)|EditOLERow]].

=Description=
{{ActivityInfoBox
| title = Edit OLE Value
| name = EditOLEValue
| image = [[File:UI_Activity_EditOLEValue .png|220px]]
| imagecaption = EditOLEValue (Expanded)
| purpose = Edit a column value of a single OLE row
| category = UBIK Data Exchange
| returns = True if successful
| version = 2.4.1+
}}

===Arguments===
{| class="wikitable sortable" | width = "50%"
|-
! Argument!! Type !! Direction !! Purpose
|- align="left"
| CreatedValue|| {{Object_MSDN}}|| Out || not used
|- align="left"
| DataRow|| {{DataRow_MSDN}}|| In|| Row to be edited
|- align="left"
| DataType|| DbType|| In || Name of activity
|- align="left"
| DisplayName|| {{String_MSDN}}|| In || Name of activity
|- align="left"
| Result|| {{Boolean_MSDN}}|| Out || Set to '''true''' for primary key columns; otherwise '''false'''
|- align="left"
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed
|- align="left"
| Value|| {{String_MSDN}}|| 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===
[[File:UI_Activity_EditOLERow_Excel.png]]
[[File:UI_Activity_EditOLERow_Arguments_Excel.png]]

===Excel document - Update an existing row===
[[File:UI_Activity_EditOLERow_Excel_02.png]]
[[File:UI_Activity_EditOLERow_Arguments_Excel_02.png]]

<headertabs />

==See also==
* [[Workflow Designer]]
* [[Activity:CreateOLETableScope (Activity)]]

[[Category:OLE]]

@@ Line 36: / Line 36: @@
 This activity is used to edit a column value of a single OLE row.
-===Excel columns===
+{{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!}}
-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=

@@ Line 38: / Line 38: @@
 =Example=
 ===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===
 {{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 />

@@ Line 42: / Line 42: @@
 ===Excel document - Update an existing row===
 [[File:UI_Activity_EditOLEValue_Excel_02.png]]
 [[File:UI_Activity_EditOLEValue_Arguments_Excel_02.png]]

@@ Line 35: / Line 35: @@
 ===Usage===
 This activity is used to edit a column value of a single OLE row.
 =Example=
@@ Line 52: / Line 55: @@
 * [[Activity:CreateOLETableScope (Activity)]]
-[[Category:OLE]]
+[[Category:OLE|EditOLEValue (Activity)]]

@@ Line 22: / Line 22: @@
 | DataRow|| {{DataRow_MSDN}}|| In|| Row to be edited
 |- align="left"
-| DataType|| DbType|| In || Name of activity
+| DataType|| DbType|| In || Column data type
 |- align="left"
 | DisplayName|| {{String_MSDN}}|| In || Name of activity and name of column

@@ Line 26: / Line 26: @@
 | DisplayName|| {{String_MSDN}}|| In || Name of activity
 |- align="left"
-| IsPrimary || {{Boolean_MSDN}}|| Out || Set to '''true''' for primary key columns; otherwise '''false'''
+| IsPrimary || {{Boolean_MSDN}}|| In || Set to '''true''' for primary key columns; otherwise '''false'''
 |- align="left"
 | Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed