Convert Records

The Conversion Groups Support table allow you to create named sets of value pairs. For example, assume that you have created tables that utilize Legacy-style STORET PCodes and you want to convert them to mnemonic PCodes you use for your project. You might create a Conversion Group called "STORET PCODES" which contains the following paired values:

You can perform a "search and replace" in-place conversion of a table using this Conversion Group using the Edit | Convert Records command, which displays this form:

For each field you want to replace, just browse to the named Conversion Group you want to utilize, and all records which contain a value matching a value contained in the "Convert From" field of the Conversion Group will be replaced with the Convert To" value. After you click Apply and confirm how many records will be changed, the table will be modified and redisplayed.

See also Support Table Browsers.