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

ID: Q129010

The information in this article applies to:

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.

Additional reference words: FixWin FoxDos 2.60a KBCategory: kbprg kbprb KBSubcategory: FxprgTable

Last Reviewed: April 18, 1995