Renumber Fields

With this tool you can renumber fields. When another object has a connection with the renumbered field the reference(s) in these objects will also be changed.

There are three possible modes.
  • Update in DB - Fields are renumbered in the database.
  • Export - Objects are exported in text format and fields are renumbered in the exported file.
  • Update text file - Fields are exported in a text file.To use the first two modes you first have to update the "Where Used Objects".

Update in DB Mode

Click Add Fields.

Add Fields
Add Fields

The lines in the renumber page can have the following colors:
  • Black- New number is equal to the original number
  • Red- New number already exists
  • Purple- New number is two times present
  • Green- Field will be renumbered

In field No. of Involved Objects you can see which objects will be updated when you renumber your selection of objects.

No. of Involved Objects
No. of Involved Objects

With the option Keep Delta Equal you only have to change one New Number. The Object Manager will apply the same delta to all other lines. If you have selected a couple of lines the delta will only apply to the selected lines. Without the option Keep Delta Equal you can modify lines separately. Press Start and the wizard will open which guide you trough the renumbering.

Renumber Fields Wizard
Renumber Fields Wizard

Export Mode

This option works the same as the Updating option, but the field in the original database are not renumbered. The renumbering is only done in the export file. The exported file is a text file which you can import in the Object Designer.

Update Text File Mode

This mode works the same as the other two modes but the fields are renumbered in a text file. You enter a filename for the source file and a filename for the file that will be created with the renumbered fields.

Export Definition to File

If you have to do the same renumbering in another database you can use the options Export and Import Definition to File.