Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 Tags
Subject: RE: Strange error
Thread ID: 104017 Message ID: 104092 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Errors & Debugging
Date: Friday, August 11, 2006 12:02:50 PM         
   


> Nope, not a row buffering issue. BufferModeOverride = 5 and that record was saved a day and a half ago. The TABLEUPDATE() did not return an error. In fact, my Child Record Change log states that the record was inserted successfully. A day and a half later, on a different machine, I still get this strange behaviour. Like I said, the data looks correct. If I select a different record and then re-select that record, it gives me no grief. It is only when I search for that record. I think that Pete is probably correct - some phantom EOF marker or something on the index. Strange thing though. You add the next child with that child ID prefix and now it is the new child record that gives me grief. I am going to take Pete and Sergey's advice and while I am on a mini vacation, I am going to get my cohort in crime to schedule some downtime and then validate the table and reindex it. Hopefully, my problem will go away.
>
> Then I can only agree. It muyst be a bad index for some reason but don't forget to tell your colleague not to use the REINDEX command, they should delete the index and re-create it (I know that you know that already) because otherwise you may not remove whatever error is causing the indeex to fail now.
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Tightline Computers Inc, Akron Ohio, USA


We rarely use the REINDEX command. Instead, I have an app that reindexes my tables. It simply the indexing code from GENDBC and just prior to creating that index I issue an ERASE ThisTable.CDX. The Admin can simply un-check all but that table and it will only take an hour or so (it takes 5 hours to do the whole database.) Your advice on a previous thread (a year or so ago) was what lead to this reindex app.

Thanks Andy,

You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

Strange error Posted by Ken Murphy @ 8/10/2006 8:18:29 PM
RE: Strange error Posted by Pete Sass @ 8/10/2006 9:37:39 PM
RE: Strange error Posted by Ken Murphy @ 8/10/2006 10:32:45 PM
RE: Strange error Posted by Joselito Watiwat @ 8/14/2006 7:32:51 AM
RE: Strange error Posted by Sergey Karimov @ 8/10/2006 9:38:33 PM
RE: Strange error Posted by Ken Murphy @ 8/10/2006 10:44:39 PM
RE: Strange error Posted by Sergey Karimov @ 8/10/2006 11:25:40 PM
RE: Strange error Posted by Ken Murphy @ 8/11/2006 1:33:41 AM
RE: Strange error Posted by Andy Kramek @ 8/10/2006 11:15:31 PM
RE: Strange error Posted by Ken Murphy @ 8/11/2006 1:47:56 AM
RE: Strange error Posted by Andy Kramek @ 8/11/2006 11:34:21 AM
RE: Strange error Posted by Ken Murphy @ 8/11/2006 12:02:50 PM
RE: Strange error Posted by Pete Sass @ 8/16/2006 10:21:42 PM
RE: Strange error Posted by Ken Murphy @ 8/17/2006 1:53:54 AM
RE: Strange error Posted by Ken Murphy @ 8/21/2006 7:06:31 PM
RE: Strange error Posted by David Hall @ 8/23/2006 12:06:06 PM
RE: Strange error Posted by Ken Murphy @ 8/23/2006 2:45:16 PM
RE: Strange error Posted by David Hall @ 8/31/2006 5:38:45 PM
RE: Strange error Posted by Ken Murphy @ 8/31/2006 6:17:39 PM
RE: Strange error Posted by Jim Winter @ 8/31/2006 6:44:57 PM
RE: Strange error Posted by tushar @ 8/31/2006 7:06:07 PM
RE: Strange error Posted by Ken Murphy @ 8/31/2006 7:41:37 PM
RE: Strange error Posted by tushar @ 8/31/2006 7:46:59 PM
RE: Strange error Posted by Ken Murphy @ 8/31/2006 8:11:52 PM
RE: Strange error Posted by tushar @ 8/31/2006 9:05:03 PM
RE: Strange error Posted by Jim Winter @ 8/23/2006 3:30:45 PM
RE: Strange error Posted by David Hall @ 9/11/2006 4:19:02 PM
RE: Strange error Posted by Ken Murphy @ 9/11/2006 4:35:59 PM
RE: Strange error Posted by David Hall @ 9/12/2006 11:10:28 AM