I'm still not sure if it's fixed, we'll see.
----- Original Message ----- From: Fred Taylor <[email protected]> To: ProFox Email List <[email protected]> Cc: Sent: Friday, May 18, 2012 5:22 PM Subject: Re: Error 2066 corruption followup To your # 3, DTOS always return 8 chars (YYYYMMDD) no matter what the SET CENTURY setting is. Not a likely culprit in different length index expressions. More likely #1 or #4 was the cause, though #4 should have alerted you to an issue, not created one. Fred On Fri, May 18, 2012 at 2:07 PM, Michael Madigan <[email protected]>wrote: > I'm writing this in case someone needs to research this later in the > archives > > > I was getting a lot of 2066 errors which is index corruption when we took > a legacy FPW 2.5 program and converted it to a VFP 9.0 program. We have > the old and the new system sharing the same databases. > > > The possible causes and solutions so far, as the number of corruptions > have gone down dramatically. > > > 1. Win 7 machines running SMB2 - I shut off SMB2 on all windows 7 > machines. > > 2. Browse noedit screens browsing the same database open in the main form > - I replaced the browse database with SQL Selects into a cursor instead. > > 3. Possible index corruption caused by DTOS(DATE) being part of index > field. Troubleshooting a different issue, it turns out perhaps CENTURY > was being toggled on and off somewhere in the program. This may cause > differences in the length of the index statement, which may cause index > corruption. > > 4. Making sure Tablevalidate is set to 0 everywhere. It was set to the > default originally. > > > So far no index corruption at all for the last 3 days and other errors > have dropped too. I'm ke[excessive quoting removed by server] _______________________________________________ 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.
