Adding a new field to a table

If you add a new field to a database table that is used in the configuration, the table will no longer be compatible with the types it is used to define in iBridge Designer. Therefore, you need to add this field to the appropriate types in the configuration.

  1. With all configuration files closed, select Tools > Fix Configuration > New Field.
  2. In the Configuration dialog, first enter the configuration file that you want to fix, including its file path. You can browse to the file by selecting the browse button next to the first text box.
  3. The file name you entered with the suffix (fixed) is automatically entered in the second text box on the Configuration dialog. At this point, you can do one of the following:
    • If you want to create a new configuration file in the same location as the original configuration file with the added suffix (fixed), leave the entry as it appears.
    • If you want to create a new configuration file with a different name or in a different location, browse to the correct location and type the new file name in the Filename box. A new file will be created in the location you specified containing the fixes you perform.
    • If you want to overwrite the original configuration file, click the browse button next to the second text box, and navigate to the original file. Be aware that if any problems occur that the original configuration file is not recoverable.
  4. The New Field dialog is displayed, displaying the types affected by the database changes in the left panel and the new fields it has found on the right. If they are not already selected, select the appropriate type and field to add and then click Add Field to add the field.
    Note: Some database tables are used to create more than one type in the configuration. If you make a change to this kind of database table, there will be more than one type listed in the left pane for the same added field. However, when you add the field to one type, this addition will be reflected for all of the other types that are created from this table.
  5. Repeat step 4 for any other fields that need to be added.
  6. The Configuration Fixer detects whether there are any more fields to add. If there are not, you will be prompted to save changes. Click Yes to save changes and No to discard all the changes that you have made.
  7. Open and re-issue the database for the changes to take effect.