Update Query Results

The results set of a Query can be updated using this tool, allowing updates of records in multiple Sessions to be made in one step, rather than opening each individual Session in Record Management and updating records a Session at a time. This feature can be used to dot out records, replace a whole value with another value, replace part of comment with a new value, clear a field, append to a text field, or fill in empty values. Event and Release dates cannot be edited with this feature and must be edited in Record Management.

Create Update Specification

This is used to build the statements that will update the query results set. Follow these steps to add one or more update specifications:

1.Select the field to update.

2.Select the operation that will be applied to that field. The options available here depend on the field selected in step 1.

3.Complete the details as required for each operation. For example, if the selected operation is Overwrite, then specify the value that will replace (overwrite) the current value in that field.

4.Click the Add button to add the statement to the Update Specifications window.

	Update Specifications
	Displays the list of statements that will be used to update the Query results. To remove a statement, click to select it and then click the Remove button.

	Backup Database
	Check this box to make a backup of the P5 database before applying the update specifications to the Query results. Having a backup would allow for restoration of the original records in the event that an update specification is applied in error.