Microsoft KB Archive/165239

= FIX: Removing Views from DBC in Project Causes Error =

Article ID: 165239

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition

-



This article was previously published under Q165239



SYMPTOMS
The following error may be returned when trying to edit a table or a view from the project manager.

DBC Internal Consistency Error

Fatal Error 550 while attempting to report error 550.

Program has performed an illegal operation.

The errors may vary but the illegal operation message will occur and FoxPro will be shut down. Another error message that might be returned is "DBC is corrupted."



RESOLUTION
In Visual FoxPro 5.0, close any open projects, open the database designer and remove the views.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been corrected in Visual FoxPro 5.0a for Windows.



Steps to Reproduce Behavior
  Create a program with the following code. CLEAR CLOSE DATA ALL CLOSE ALL SET EXCLUSIVE ON     SET SAFETY OFF

ERASE test.pjx ERASE t1.dbf ERASE t2.dbf

CREATE DATA test

CREATE TABLE t1 (name c(10)) INSERT INTO t1 (name) VALUES ("test") INSERT INTO t1 (name) VALUES ("TEST") INSERT INTO t1 (name) VALUES ("test") INSERT INTO t1 (name) VALUES ("test")

CREATE TABLE T2 (addr c(10)) INSERT INTO t2 (addr) VALUES ("addr") INSERT INTO t2 (addr) VALUES ("addr") INSERT INTO t2 (addr) VALUES ("addr") INSERT INTO t2 (addr) VALUES ("addr")

CREATE SQL VIEW xx as SELECT * FROM t1     CREATE SQL VIEW x2 AS SELECT * FROM t1      CREATE SQL VIEW x3 AS SELECT * FROM t1      CREATE SQL VIEW x4 AS SELECT * FROM t1      CREATE SQL VIEW x5 AS SELECT * FROM t1      CREATE SQL VIEW x6 AS SELECT * FROM t1

CLOSE TABLES MODI PROJ TEST NOWAIT  After running the code, add the test database to the project. While in the project manager, remove two or three views by selecting the view and choosing Remove. From the project manager, modify the database and select "Clean Up Database" from the Database menu. This will pack the .dbc file. Close the Database Designer window, and return to the project. Click on a view.</ol>

The error may not be returned on the first view. Click on a few views and the error eventually occurs.

Additional query words: data base

Keywords: kbbug kbfix kbvfp500afix KB165239

-

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

© Microsoft Corporation. All rights reserved.