[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 DBFNTX/1210  Corruption detected

     Explanation:  The index and the database files are "out of sync"
     with each other.  This is usually due to the index key expression
     evaluating to a variable length.

     Action:  Some suggestions to resolve the problem are:

     1. Recreate the indices for the database. Ensure that all indices are
        open when the database is updated.  Check for other causes of
        corruption as well (EMS memory, network problems, improper RDD,
        etc.).

     2. Check that ALL index key expressions are a constant length.  Usage of
        LTRIM(), RTRIM(), TRIM(), ALLTRIM(), STR(), DTOC() can all produce
        expressions that are not a constant length.  The xTRIM() functions
        should all be padded out to a constant width using PADR().

     3. Use all 3 arguments to STR().

     4. Use DTOS() instead of DTOC() in index key expressions.  DTOC() is
        dependent upon the SET DATE FORMAT.

     5. Using a field or expression aliased into a different work area will
        also cause this error--e.g., area2->field1 or area2->( str( fld1, 5,
        0 ) ).



This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson