Renumber Objects

With this tool you can renumber objects. When another object has a connection with the renumbered object the reference(s) in these objects will also be changed. It even is possible to renumber tables with data in it. There are three possible modes.
  • Update in DB - Objects are renumbered in the database.
  • Export - The objects are renumbered and exported in text format.
  • Update text file - Objects are renumbered in a text file.

Update is recommended because all data in the Object Manager will also be renumbered. If you choose for the export mode, the data will stay the same.

Update in DB Mode

Click Renumber Objects and then click Add Objects.

Add Objects
Add Objects

In field No. of Involved Objects you can see which objects will be updated when you renumber your selection of objects. In the following example you can see that the Resource table also will be updated because is has a reference to the Car table.

Involved Objects
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 the lines separately. The lines in the renumber page can have the following colors:
  • Black - New number is equal to original number.
  • Red - New number already exists.
  • Purple - New number is two times present.
  • Green - Object will be renumbered.

Press Start and a wizard will open which guide you through the renumbering.

Renumber Objects Wizard
Renumber Objects Wizard

Export Mode

This option works the same as the Updating in DB option, but the objects in the original database are not renumbered. The renumbering is only done in the exported file. The exported file is a text file which you can import in the Object Designer. Choose option Export, and select the filename for the text file.

Export Mode
Export Mode

Press Start to initiate the renumbering and the file will be created.

Update Text File Mode

This mode works the same as the other two modes but the objects 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 objects.

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.