Kbase P40644: How to update Queries after a database schema modification.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/20/2003 |
|
Status: Unverified
GOAL:
How to update the existing results reports after a schema modification.
FIX:
2.2.5 Database Schema Changes
Database schema changes, such as creating, modifying, or deleting a field, index, or table, can break existing Results queries.
Field and table additions and deletions in an application database automatically register in the field and table listings in Results. However, schema modifications do not automatically register in the table relationships maintained in the current QC7 file, or in any existing queries based on those relationships.
Follow these steps to rebuild table relationships and regenerate existing queries based on those relationships:
Choose Query> Site Admin> Application Rebuild. The Application Rebuild dialog box appears.
The Application Rebuild dialog box lets you rebuild both the table relationships and existing queries or just the table relationships.
To start the rebuild process, select one of the rebuild options, then choose OK.
If you choose to rebuild both the table relationships and existing queries, Results displays the Select Query Directory dialog box, which allows you to select the directory of queries you want to rebuild:
Select the queries you want to rebuild, then choose OK.
When there are no more query directories to rebuild, choose Cancel to end the rebuild operation.
During the rebuild operation, Results writes any problems encountered during the build process to the QL file associated with the current QC7 file. Use this information to identify problem queries that could not be rebuilt by Results. See the "Database Configuration Files" section for more information about QC7 and QL files.