Changing Matchcode Objects

This section describes what you should be aware of when changing an existing matchcode object.

Changing the Primary Table

You can change the primary table by simply entering a new table name in the field Primary table.

A warning is given if you already selected secondary tables or fields. If you confirm the changes to the primary table by entering data, all the dependent objects (secondary tables and fields) are deleted.

If the matchcode object already has some matchcode IDs, you cannot change the primary table without first deleting these IDs.

Removing Secondary Tables

To remove a secondary table from the matchcode object, position the cursor on the table and choose Edit -> Delete SecTab.

Deleting a table from the matchcode object also removes all the tables which are linked with the primary table via the deleted table.

Including Other Secondary Tables

If you want to include other secondary tables, position the cursor on the table name and choose Edit ® Choose sec. tab. A list of all the tables linked with the selected table with foreign key is displayed.

Position the cursor on a table which you want to include as secondary table and choose Choose. The table is highlighted. Repeat this for all the tables you want to include in the matchcode object. Then choose Copy.

You return to the maintenance screen. The selected tables are included as secondary tables and the corresponding foreign key is displayed. Save the table selection once you have included all the required tables.

Deleting Fields

To delete a field, position the cursor on the relevant field and choose Edit ® Delete field. Key fields cannot be deleted.

Before you delete a field from a matchcode object, you must make sure that this field is not used in any of the matchcode IDs for this object. Otherwise an error occurs when you try to activate the matchcode object! You can correct this error by deleting the relevant field from all the IDs of the matchcode object or by simply including the field again in the matchcode object.

Inserting Fields

To insert a field, position the cursor on a field which was already entered and choose Edit ® Insert field. A new line is opened directly above the line containing the cursor. You can make the necessary entries in this line.

Changing the Search Field

In order to be able to use matchcodes as online help, there must be a link between a field on the screen and a matchcode field. You can make this link with the search field, which is assigned to the first key field of the primary table as default.

In a matchcode selection within the online help, the value of the search field is copied to the screen. To choose a different search field, you only have to select it in the appropriate column.

Only one field may be selected as search field!