Key change

This function is used to perform a mass key change.

It is possible to enter or load the grid by selecting records for a given object.

For instance:

Object	Object title	Identifier 1	Identifier 2	Title	New code
ADI	Miscellaneous table	ACO	1		ZZZ
BPC	Customers	CLIENT1			CLIENT2

Principle

For each line in the grid, the key change is equivalent to the manual key change carried out by the user.

The key change consists in changing the code in all the records contained in the database.

The link between the modified code and the other tables containing this code is defined in the table dictionary.

Screen management

Entry screen

Field descriptions

Block number 1

Folder (field APPLI)

Define the folder code, as it is defined in the folders table, in which the work will be carried out.

Grid

Code (field COD)

Description (field INTIT)

[object Object]

Block number 3

Simulation (field SIMUL)

When this box is checked, the operation is not really executed, but only simulated. The resulting detailed trace file describes what would have been performed if the operation had not been executed in this mode.

Loads into the grid all the records on:

Object
selection on the fields of the object

Batch task

This function can be run in batch mode. The standard task ACHANGE is provided for that purpose.

Memo

is used to save the setup values entered, by giving a name to the memo. Remembering that the memo STD, if it exists, is automatically recalled when a print is launched.

Recall

makes it possible to recall a memo by giving its code.

Delete Memo

Allows the deletion of an existing memo.

Deferred

Used to launch the key change in deferred mode.

Error messages

Generic messages

The only error messages are the generic ones.

Tables used

See also Refer to documentation Implementation

Important remark

This utility is used to process application table keys on a single folder. Thus it is advised not to use it to rename keys existing in Supervisor tables or tables of type System.