You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
Turn on Animations
SharePoint
Sign In
Use SHIFT+ENTER to open the menu (new window).
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Browse
Tab 1 of 2.
Page
Tab 2 of 2.
Follow
Bluespring Online
Bluespring ProcessView
Bluespring LeanView
BPM5 Documentation
Currently selected
Updating All the Records in the Database Table
It looks like your browser does not have JavaScript enabled. Please turn on JavaScript and try again.
Updated Pages
Update Specific Group LDAP Entries
Home
Write Values to a Password-protected Workbook and Worksheet
Write Data Item Values to a Delimited Text File
Update Specific User LDAP Entries
Documents
Welcome & Introduction
Guides
Hardware & Software Requirements (PDF)
Install Guide (PDF)
Activity Reference Guide (PDF)
BPM Designer Topics
Workspace and Solution Topics
Solution Item Topics
Activity Topics
Common Expression Functions
BPM Admin Topics
Process and Activity Monitoring (with Filters)
Service Monitoring
View All Site Content
Recent
Images
Business View Topics
Feedback
Solution Items and Activities
Guides
Home
About
To update all records in the database table, complete the following steps:
Check out and open the process you want to edit.
In the
Toolbox
pane, click
Database
. A list of activities is displayed.
Double-click or drag the
Update Database Records
activity into the process.
Link the activity appropriately with other activities.
Right-click the
Retrieve Database Records
activity, a shortcut menu is displayed,
Select
View Properties
. The
Retrieve Database Records
window is displayed.
Click the
Database and Table
tab. The
Database and Table to Retrieve Records from
section is displayed.
In the
Database
field, click the
System Resource
icon. A drop-down list is displayed.
Select the relevant ODBC System Resource. The selected resource is displayed in the field.
Note:
If your system resource contains a data item in the connection string property, click
Configuration Values
and enter a valid connection string for design-time, configuration purposes.
In the
Table
field, click the
Table
icon. A drop-down list is displayed.
Select the relevant database table. The selected table’s name is displayed in the field.
Right-click the
Update Database Records
activity, a shortcut menu is displayed,
Select
View Properties
. The
Update Database Records
window is displayed.
Click the
Update Criteria
tab. The
Update Criteria
options are displayed.
Note:
By default, the Update all records in the database table option is selected.
Click the
Data Mappings: Update Records
tab. The corresponding screen is displayed.
Select either the automatic or manual option for mapping values to table columns.
Note:
For details on automatic and manual mapping options, see the corresponding topics in this section.
Click
OK
. You configured the activity to update all records in the database table.
Related Topics
Updating Records that Meet Specific Criteria
Automatically Determining which Columns to Update with Data Item Values
Manually Determining which Columns to Update with Data Item Values, Expression Results, or Literal Values
Rolling Back and Undoing Updates to Records when an Error Occurs
Source
BPM Designer Topics
>
Overview of Activities and Activity Topics
>
Database Activities
>
Update Database Records
Last modified at 7/31/2020 12:05 PM
