Microsoft KB Archive/191593

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

Article ID: 191593

Article Last Modified on 5/12/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q191593



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.



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: kbbug kbnofix KB191593

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.