FIXDB23

Program to update 4.5xx databases for use with 4.6xx releases. The database remains compatible with 4.5xx. This program runs with rollback logging disabled, so make sure you ahve a copy of your database in case anything goes wrong and you need to restore your database and rerun FIXDB23.

You can also use this program against a 4.6xx database if you want to adopt a new standard form for names

Command Tail Description

−SYSTEM

Supply this (with -DB SYSTEM) to run against the system database

−KEY

Makes extra checks on key fields to fix earlier bug in MAKEDB

−MAPS

Reconvert maps from 4.500

−FIXMAPS

Correct problems caused by bugs in MAPEDIT

−CCNAMES

Convert dictionary and QAB names to camel case (REC_NAME to recName)

−LCNAMES

Convert dictionary and QAB names to lower case (REC_NAME to rec_name)

−MCNAMES

Convert dictionary and QAB names to mixed case (REC_NAME to RecName)

−UCNAMES

Convert dictionary and QAB names to upper case (recName or rec_name or RecName to REC_NAME)

−NOEMBEDDED

Create overlapping controls instead of embedded fields

−NOAUTO

Ignore automatically generated alignment characters in 4.500 maps

−NOBOXES

(From 4.618) Remove 4.5xx box characters from converted maps

−SMARTEN

Automatically convert dialogs to 3D appearance

−SMARTENMORE

(From 4.618) Similar to -SMARTEN but works on maps that may not be dialogs - may be useful for databases designed for text based systems.

−SMARTENMORE

Similar to -SMARTEN but works on maps that may not be dialogs - may be useful for databases designed for text based systems.

−QAB

Restricts name case conversion options to working only on QAB name table.

−DD

Restricts name case conversion options to working only on database name table.

You can specify both -QAB and -DD to convert just table field and QAB names. Without either option all type S fields in the base dictionary will be converted, e.g. Report Names, Printer names etc.