Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Khurram Tahir
  Where is Khurram Tahir?
 Karachi
 Pakistan
 Khurram Tahir
 To: Rick C. Hodgin
  Where is Rick C. Hodgin?
 Indianapolis
 Indiana - United States
 Rick C. Hodgin
 Tags
Subject: RE: cdx corrupting again and again
Thread ID: 364938 Message ID: 365224 # Views: 25 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, December 22, 2012 1:31:20 PM         
   


> >
> > What is this?
> > even you have involved recno()
> > Rahul
>
>
>
> I think you may have nailed it, Rahul. The index is changing because records are being added or deleted which alter their recno() values. Since the index is only updated for changed entries, the recno() will change with its index keys not being updated. Upon re-use of the CDX this discrepancy is found.
>
> Khurram, remove that index tag and see if the errors persist. If that fixes it, use an iid field which is unique in place of recno() and it should solve your problems.
>
> Best regards,
> Rick C. Hodgin

Rick Thanx , Earlier Rahul also pointed this thanx to Rahul too

ENTIRE THREAD

cdx corrupting again and again Posted by Khurram Tahir @ 12/20/2012 10:50:42 AM
RE: cdx corrupting again and again Posted by Tore Bleken @ 12/20/2012 10:53:43 AM
RE: cdx corrupting again and again Posted by Khurram Tahir @ 12/20/2012 11:04:10 AM
RE: cdx corrupting again and again Posted by David Mustakim @ 12/20/2012 11:14:54 AM
RE: cdx corrupting again and again Posted by Russell Hill @ 12/20/2012 11:28:43 AM
RE: cdx corrupting again and again Posted by David Mustakim @ 12/20/2012 1:17:09 PM
RE: cdx corrupting again and again Posted by Russell Hill @ 12/20/2012 9:16:06 PM
RE: cdx corrupting again and again Posted by Tore Bleken @ 12/20/2012 11:17:46 AM
RE: cdx corrupting again and again Posted by Khurram Tahir @ 12/20/2012 1:20:00 PM
RE: cdx corrupting again and again Posted by David Mustakim @ 12/20/2012 1:34:30 PM
RE: cdx corrupting again and again Posted by Rahul Moudgill @ 12/21/2012 6:16:10 PM
RE: cdx corrupting again and again Posted by David Mustakim @ 12/20/2012 1:30:22 PM
RE: cdx corrupting again and again Posted by Tore Bleken @ 12/20/2012 1:56:23 PM
RE: cdx corrupting again and again Posted by Rick Hodgin @ 12/20/2012 8:17:52 PM
RE: cdx corrupting again and again Posted by Tore Bleken @ 12/20/2012 8:35:13 PM
RE: cdx corrupting again and again Posted by Rahul Moudgill @ 12/20/2012 11:18:39 AM
RE: cdx corrupting again and again Posted by Rick Hodgin @ 12/20/2012 8:28:21 PM
RE: cdx corrupting again and again Posted by Tore Bleken @ 12/20/2012 8:36:27 PM
RE: cdx corrupting again and again Posted by Rick Hodgin @ 12/20/2012 8:40:06 PM
RE: cdx corrupting again and again Posted by Khurram Tahir @ 12/22/2012 1:31:20 PM
RE: cdx corrupting again and again Posted by Pete Sass @ 12/20/2012 8:54:54 PM
RE: cdx corrupting again and again Posted by Rahul Moudgill @ 12/21/2012 6:10:39 PM
RE: cdx corrupting again and again Posted by David Mustakim @ 12/20/2012 11:08:43 AM
RE: cdx corrupting again and again Posted by mk sharma @ 12/20/2012 11:32:37 AM
RE: cdx corrupting again and again Posted by Pete Sass @ 12/20/2012 6:40:05 PM
RE: cdx corrupting again and again Posted by tushar @ 12/20/2012 6:49:10 PM
RE: cdx corrupting again and again Posted by Khurram Tahir @ 12/20/2012 7:04:27 PM
RE: cdx corrupting again and again Posted by Khurram Tahir @ 12/20/2012 7:04:31 PM
RE: cdx corrupting again and again Posted by Pete Sass @ 12/20/2012 7:26:19 PM
RE: cdx corrupting again and again Posted by Rick Hodgin @ 12/20/2012 8:23:27 PM