Name: AUTOFIX Shortest: AUTOFIX
Family: Command Category: Data Integrity
Description: Use AUTOFIX, an external DOS utility, to repair broken pointers. Pointers, which link rows in a table, can become damaged, and then R:BASE is unable to find rows in the database.

Syntax
AUTOFIX syntax diagram

Options

dbname
Specifies the name of the database.

tblname
Specifies the table name.

About the AUTOFIX Command

AUTOFIX.EXE is a stand-alone DOS utility included in the installation directory. Use the AUTOFIX command to fix a database with broken pointers in tables without columns with NOTE or with LOB data types such as VARCHAR or VARBIT. If rows will be lost, the number of rows affected is displayed, and the user is asked whether to continue with the repair.

AUTOFIX uses the calculated row size of a given table and searches the database for rows which match that size. For this reason tables with rows of variable width, such as those that contain note columns, or tables with rows that contain pointers to the Binary file (RB4), such as tables that contain VARBIT or VARCHAR columns, can not be AUTOFIXed.