BUG: ALTER TABLE Causes Memo File is Missing or Invalid Err

ID: Q191593

The information in this article applies to:

Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a, 6.0

SYMPTOMS

Using the Alter Table command to add a column to a FoxBASE+ table with a memo field causes the following error message:

Memo file is missing or invalid.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

Create a program (.prg) file and add the following code to the .prg file:


      CREATE CURSOR DummyTable (Code C (5), MemoField M)
      FOR i = 1 to 10
         APPEND BLANK
      ENDFOR

      COPY TO Foxold TYPE FOXPLUS
      USE Foxold EXCLUSIVE
      ALTER TABLE Foxold ADD COLUMN Descr C(80)

Save and run the .prg file.

NOTE: The program errors out with the error message shown in the SYMPTOMS section.

Additional query words: kbVFp300bbug kbVFp500abug kbVFp600bug KbDBFDBC kbDatabase

Keywords :
Version : WINDOWS:3.0,3.0b,5.0,5.0a,6.0
Platform : WINDOWS
Issue type : kbbug