Changes

HowTo:Update Data via OLEDB with a Workflow

6 bytes removed, 09:53, 11 February 2015
# Once you determine the row to be updated, use [[OLEEditRow (Activity)]] to start editing.
# Define the primary key column(s) by using [[EditOLEValue (Activity)]] activities within OLEEditRow. You need to specify the column name in the '''DisplayName''' property and the data type in the '''DataType''' property. Check the '''IsPrimary''' checkbox for all columns defined in this step (key columns).
<br/>
{{Attention|The primary key column '''must be defined''' when updating data via OLE DB.}}
# Define the data column(s) to be updated by using EditOLEValue activities within the OLEEditRow. Again, you need to specify the column name in the '''DisplayName''' property and the data type in the '''DataType''' property. Specify the '''new value''' for the cell in the property '''Value'''.
10,686
edits