Was this helpful?
How Vision Reconciles Frame Definitions
When you change a table and run the Reconcile utility, Vision makes the following changes to the visual queries for all frames that use that table:
If You Make This Change to a Table:
Then Vision Makes This Change to the Frame Definition:
Delete a Master or Detail table from the database
Vision cannot modify the frame definition.
Delete a Lookup table from the database
Deletes the Lookup table from visual query.
Delete a column from a table
Deletes the column from the visual queries.
Vision also deletes any escape code using this column and displays the escape code in the reconciliation report.
If the column you delete is used as a join column, Vision deletes the join.
Add a column to a table
Adds the column as non-displayed to the visual queries.
Change the data type or nullability of a column
Changes the column's data type or nullability in the visual queries.
If you change the data type of a join column so that the join is no longer valid, Vision deletes the join and notes this fact in the reconciliation report.
Change the key columns for a table
Adjusts the visual queries as necessary.
The reconciliation report notes whether any changes cause a visual query to be invalid; for example, by deleting a join column. Also, you must re-specify column titles for Lookup table selection lists after you run the Reconcile utility.
Last modified date: 12/14/2023