Correction below in Section 1) and 2)
________________________________ From: Jean Haidar <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Tuesday, December 9, 2008 12:19:41 PM Subject: VFP index corruption UPDATE (lcUpdateTable) ; SET &lcUpdate WHERE case_id = &lcCurRecord..case_id Error get generated like 7 times between mid November to first December 2) A form Querying the table ( Select statement include Profile and other table) Error generated like 4 times between mid November to first December Any ideas? Thanks, Jean [EMAIL PROTECTED] --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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. Report [OT] Abuse: http://leafe.com/reportAbuse/[EMAIL PROTECTED] 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: --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
