Technote Details :: Synchronize tables

When trying to edit an older query, some of the table fields are marked with a red cut-through line.

• Products: MX Query Builder.

• Operating System: All.

• Server Models: All.

• Dreamweaver version: any.

This happens because some of the table columns used in the initial query no longer exist in the database. MX Query Builder highlights these by placing a red mark on the columns it can't find. These columns cannot be used in the query anymore.

There are two solutions to this issue:

1. Alter the tables, and add the missing columns. When you re-open MX Query Builder with the same stored query, the columns will be usable again.

2. Right-click on the table that displays the missing columns and select Synchronize. This will update the displayed query tables by removing the columns. On save, the query will be updated.