PRB: Using FoxBASE+ .DBT Type Memo Files

ID: Q98747

The information in this article applies to:

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>

Note that the information listed for the memo field in record one contains additional, incorrect information.

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.

Additional reference words: FoxDos 2.50 2.50a browse modify memo dbt dbase KBCategory: kb3rdparty kbprb KBSubcategory:

Last Reviewed: April 17, 1995