Changes

Activity:EditOLEValue (Activity)

1,707 bytes added, 15:28, 23 February 2015

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

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]]

KNO

10,686

edits