Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Emerson Reed
  Where is Emerson Reed?
 Americana - SP
 Brazil
 Emerson Reed
 Tags
Subject: Table has become corrupted
Thread ID: 112239 Message ID: 112239 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, November 06, 2006 2:58:37 PM         
   


I'm trying to open a table in VFP (in the command window) and receiving an error:
2091 - Table has become corrupted. The table will need to be repaired before using again.
If I issue a set TableValidate To 0 command and try to open the table again, I receive a message "Memo file repaired. Proceeding" and the table is opened correctly.

If I do the same in my application at run time, after issue a set TableValidate To 0 command, and try to open again, I receive an error:
41 - Memo file is missing or is invalid.

Why not working at run time?

Emerson Santon Reed
http://weblogs.foxite.com/emersonreed
http://thespoke.net/blogs/emersonreed

ENTIRE THREAD

Table has become corrupted Posted by Emerson Reed @ 11/6/2006 2:58:37 PM
RE: Table has become corrupted Posted by Pete Sass @ 11/6/2006 4:12:22 PM
RE: Table has become corrupted Posted by Emerson Reed @ 11/6/2006 5:07:20 PM
RE: Table has become corrupted Posted by Pete Sass @ 11/7/2006 5:41:44 PM
RE: Table has become corrupted Posted by Boudewijn Lutgerink @ 11/7/2006 8:30:02 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/7/2006 11:12:05 AM
RE: Table has become corrupted Posted by Boudewijn Lutgerink @ 11/7/2006 11:51:15 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/8/2006 11:43:02 AM
RE: Table has become corrupted Posted by Pete Sass @ 11/8/2006 9:15:19 PM
RE: Table has become corrupted Posted by Emerson Reed @ 11/10/2006 1:18:06 PM
RE: Table has become corrupted Posted by Ilya Rabyy @ 11/9/2006 1:00:12 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/10/2006 1:26:14 PM
RE: Table has become corrupted Posted by Ilya Rabyy @ 11/10/2006 4:49:31 PM
RE: Table has become corrupted Posted by Bob Brook @ 11/10/2006 5:09:17 PM