PRB: Appending from dBASE IV Table That Has Memo Causes Error

• Microsoft FoxPro for Windows, version 2.6a
• Microsoft FoxPro for MS-DOS, version 2.6a

SYMPTOMS

Appending from a dBASE IV file that has a memo field causes a "Cannot convert Memo file for a read-only file" error message.

RESOLUTION

Make a copy of the dBASE IV database and memo files (*.DBF and *.DBT files). Then use the database file. FoxPro will prompt you to convert the memo file. You should then be able to append from the file.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

1. Make a copy of a dBASE IV table (*.DBF) and its associated memo file (*.DBT)

2. USE the newly created copy. A message box "Convert MEMO file to FoxPro Format?" will appear. Answer "Yes." Another message box "Remove dBASE

      'soft' carriage returns from memos?" will appear. Answer "Yes." A
      "Structural CDX file not found" message may or may not appear. Ignore
      the message if it appears.
   
   

3. Append from the original table by using the APPEND FROM command. A message box "Convert MEMO file to FoxPro Format?" will appear. Answer "Yes."

4. A "Cannot convert Memo file for a read-only database file" error message will appear.

5. Append from the copy with the converted memo file. The error message should not appear.