Open topic with navigation

SYNCHRONIZE TABLE

This process will realize a comparison between the definitions of the application fields and the table fields that has origin in the database. In case that in origin table occurs any update, as for example the inclusion of a new field, or exclusion, or still a change in the data type, this update will show it visible as seen in the image below:


Image1: Synchronize table function interface.

After accessing the function from the link “Synchronize table” is show a comparison table between the application fields (left table) and the table fields of the database (right table), above Image, the marked fields in “red” will be deleted of the application, the marked fields in “Green” will be inserted in the form, and the marked fields in “orange” will be updated, so they suffer type update in the database.

Note: When a table field in the database is renamed, the effect of the table synchronization, comparatively, will be the same of the exclusion of a field that exist in the application plus the inclusion of a new field.