Updating Database Records

Automate database record updates with the Database Book.

To update an existing database record, you need to first identify the record to be updated. To learn more about this, see Retrieving Database Records and Storing Retrieved Records.

Example

get a database's person whose FirstName is "Jane"
use the above as the records
use the first record as the person
set the person's DOB to '1990-01-01'

In this example:

• Line 1: Retrieves a database record.

• Line 2: Stores the retrieved records as the records.

• Line 3: Stores only the first record from the records as the person.

• Line 4: Updates the DOB of the person.

Note: This Book does not support updating multiple column records simultaneously. To update multiple column records, please update each record individually.