Jean Haidar wrote: > We have problems with one of VFP TABLE , it give an intermittent error message like this > > Index file "\\lrd1fil2\vfpprod\mw\mwdata\profile.cdx" is corrupted. Please rebuild it. > > we are rebuilding the PROIFLE.DBF often ; sometimes every 2 days by using these commands: > > for example: > > USE R:\MWDATA\PROFILE in 0 > select profile > copy to c:\data\PROFILE.dbf > USE C:\DATA\PROFILE IN 0 EXCL > > here we rebuild the indexes like this: > > INDEX ON CASE_ID TAG CASE_ID > INDEX ON CUST_ID TAG CUST_ID > etc.. > > PROIFLE has about 29 index tags and profile.dbf is about 1.1 gig in size > > we are able to add and update records most of the time but sometime we are getting the error message above > from different processes: > > 1) A batch process trying to update the DBF with an update statement like this: > UPDATE > case_id = &lcCurRecord..case_id > > Error get generated like 7 times between mid November to first December > > 2) A > Error generated like 4 times between mid November to first December > > (lcUpdateTable) ; SET &lcUpdate WHERE ;form Querying the table ( Select statement include Profile and other table) > Any ideas? > > Thanks, > Jean > [EMAIL PROTECTED]
Hi Jean, There's a problem called Stonefield Database Toolkit that is absolutely great at DBF index and structure maintenance. Check it out here: http://stonefield.com/sdt.aspx It's absolutely worth the $495 price. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
