Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Frequent table corruptions
Message
From
01/10/2004 08:57:26
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
01/10/2004 05:28:20
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00947849
Message ID:
00947903
Views:
14
>Hi all.
>
>I have an VFP6 network application running on 4/5 years. I get table corruptions (nº records <> header reccount) once, twice a year... usual I gess.
>Since I upgraded to VFP8 I get the error: (2091) "Table "name" has become corrupted..." almost every day!!
>The only thing I change in code was a new line "Set ENGINEBEHAVIOR 70" because o had no time to change some reports.
>Any ideas will be great.
>Thanks in advance,
>NPedro

Two things you should check:

1) After making changes to any record (after TableUpdate(), if you use buffering), you should give the command FLUSH.

2) It seems that a write-cache on the hard disk can cause problems.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform