Changes

HowTo:Update Data via OLEDB with a Workflow

No change in size, 08:12, 29 January 2015
3. Iterate throw the fetched rows by using e.g. a FOR - EACH activity.<br/>
4. Once you found the row you want to update, use an "OLEEditRow" to make it editable.<br/>
5. Define the primary key data structure by placing "EditOLEValue" activities inside the OLEEditRow. Yoe You need to specify the column name in the "DisplayName" property and the data type in the "DataType" property. Check the "IsPrimary" checkbox as this column is the key column.<br/>
<br/>
{{Attention|The primary key column "must be defined" when updating data via OLE DB.}}
6. Define the data cells you want to update by placing "EditOLEValue" activities inside the OLEEditRow. Yoe 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 evaluation property "Value".<br/>
1,579
edits