PRB: Using FoxBASE+ .DBT Type Memo Files

• Microsoft FoxPro for MS-DOS, versions 2.5 and 2.5a

SYMPTOMS

Memo field contents appear corrupted, or contain additional incorrect data when contained in a .DBT (FoxBASE+ or dBASE) style memo file and then viewed in FoxPro versions 2.5 and 2.5a for MS-DOS. The memo field will appear to contain the information entered in it along with other random characters and information stored in the memo field for other records.

CAUSE

When the contents of the memo field is changed from FoxBASE+ or dBASE, the .DBT memo file is updated. FoxPro 2.5 and 2.5a for MS-DOS have a problem reading the pointers in this file correctly.

RESOLUTION

Each time the database is brought into FoxPro 2.5 and 2.5a for MS-DOS after changes have been made in FoxBASE+, the command PACK MEMO must be issued before viewing the memo field.

MORE INFORMATION

Steps to Reproduce Problem

1. Start FoxBASE+ version 2.1.

2. Type the following at the dot prompt:

         CREATE test.dbf && with one memo field
   

3. When prompted, add two or three records to the database, entering data into the memo field for these records.

4. Quit FoxBASE+.

5. Start FoxPro 2.5 or 2.5a for MS-DOS (16- or 32-bit).

6. Type the following in the Command window:

         USE test.dbf
   

7. Type the following in the Command window:

         LIST <memo field>
   

dBASE is manufactured by Borland International Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.