Was this helpful?
Reconciling Tables and Frame Definitions
After you begin to develop a Vision application, you can change a table used in your visual queries; (for example, adding a column or specifying a different data type for a column) by recreating the table in the Tables Utility with a different definition (see Character-based Querying and Reporting Tools User Guide for details on using the Tables utility).
If you change a table, the visual queries for any frames that use this table do not reflect the changes automatically. However, Vision provides a utility to reconcile frame definitions to match any changes made to the tables they use.
You can use the Reconcile utility with any frames in an application, including those that you have removed from the application flow diagram. The Reconcile utility:
Checks for discrepancies between the tables in the database and the definitions of the frames that you specify
If it finds any discrepancies, lets you tell Vision to change the frame definition to match the table structure or to reject the changes
The Reconcile utility operates on a "per frame" basis. You must accept or reject all changes to a frame; that is, if there are multiple changes to a frame, you cannot accept some and reject others.
Note:  If the changes to your application are fairly complex, you can reject them when you run the Reconcile utility and write the reconciliation report to a file. After studying the changes that Vision proposes and considering their impact on your application, you can accept the changes by running the Reconcile report again.
You can use the Reconcile utility to experiment with your tables. You can change a table and run the utility for all frames that use the table. The Reconcile utility shows you how these changes affect the frame definitions. You can view the report and write it to a file, and reject the changes so that Vision does not make the changes permanent.
Also, if other developers are using the same tables, you can run the Reconcile utility periodically to check on any changes to tables that they have made that affect your applications and frames.
Last modified date: 01/30/2023