Microsoft KB Archive/98747

{| = PRB: Using FoxBASE+ .DBT Type Memo Files =
 * width="100%"|

ID: Q98747

The information in this article applies to:


 * 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.

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 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:
 * }