Jean, I think I agree with you i.e. why look for a toolkit when your command is perfectly legitimate
I think you're saying this problem started just recently. I had a similar issue, and the problem went away after I re-booted the Server. Then it came back I copied all the tables + cdx's to a different folder. Problem went away. Then it came back I freed up diskspace (it was down to 1 gig on a 200 gig server) Problem went away (2 weeks ago and still not back.....................) Sytze On Wed, Dec 10, 2008 at 7:56 AM, Jean Haidar <[EMAIL PROTECTED]> wrote: > we are only dealing with DBF not DBF/DBC. > > What methology the SDT utility is using in terms of fixing indexes other > than what we currently doing? > do you know? > > use CUSTOMER > delete tag all > index on CUST_ID tag CUST_ID > index on POSTALCODE tag POSTALCODE > > > Thanks, > Jean > > > > > ________________________________ > From: MB Software Solutions General Account <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Sent: Tuesday, December 9, 2008 12:57:56 PM > Subject: Re: VFP index corruption > > 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. > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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.
