Updates a values in a db field

Last published at: May 14th, 2024

Description:

Updates a value within a given database row and column

Inputs

  • connectionString – connection string to the database
  • tableName – name of the database table
  • changeDatabase – connect to different database
  • fieldName – name of the field to update
  • fieldValue – value to update
  • whereFieldName – name of the where clause field
  • whereFieldValue – value of the where clause field 

Returns

  • True – step executed successfully
  • False – step failed to execute 

Usage:

Example:

Let’s build and execute the updateDBFieldValueDef example.          

  • Create a new definition called “updateDBFieldValueDef
  • Select the definition and click the “design” button
  • Drag a updateDBFieldValue step to the canvas
  • Connect the dots between the start and updateDBFieldValue steps

  • Click on the “updateDBFieldValue” step to configure its properties
  • Configure the following values for the properties as shown on the below graphic
  • Click the “Save” button
  • Save the workflow definition, create a workflow instance and execute. Step should update the DB field.