Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 129646 - Last Review: September 30, 2003 - Revision: 3.1
FIX: Error Routine Not Called for USE Command
This article was previously published under Q129646
Visual FoxPro will not trap for the error caused by trying to open a table
that is part of a corrupted database.
Usually, the "USE customer" command will open the table and the database
that the table is part of. If the Database is corrupt, the following
message is displayed:
The database for table C:\..\CUSTOMER.DBF could not be opened. Would you
like to try to locate the owning database or delete the link (and free
the table). Locate Delete Cancel
In a program with an error routine, the error routine is not called, and
the above message is still displayed. Selecting Cancel ends the program.
Do not open a table that is part of a database without first opening the
database. Then you can trap for the error generated by trying to open a
corrupt database.
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem has been fixed in
Visual FoxPro 5.0 for Windows.
Steps to Reproduce Problem
Corrupt the TESTDATA database by opening it as a table and deleting the
first record. Run the following program:
SET DEFAULT TO C:\VFP\SAMPLES\DATA
ON ERROR DO errhand WITH ERROR(), MESSAGE()
USE customer
ON ERROR
PROCEDURE errhand
PARAMETERS errno, errmsg
WAIT WINDOW STR(errno)+" "+ errmsg
RETURN
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 3.0b Standard Edition
| kbbug kbfix kbvfp500fix KB129646 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please