Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table has become corrupted
Message
From
06/11/2006 09:49:36
 
 
To
06/11/2006 09:00:13
Emerson Reed
Folhamatic Tecnologia Em Sistemas
Americana - São Paulo, Brazil
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01167289
Message ID:
01167300
Views:
7
>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?

You must use Set tablevalidate to 0 for one reason only, and that is to fix the table!
lnTablevalidate=Set("TableValidate")
Set tablevalidate to 0
use yourtable exclusive
pack memo && Will usually fix the error!
use
Set tablevalidate to lnTablevalidate
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform