[Babase] Dump problem?

Karl O. Pinc kop at meme.com
Wed May 30 12:46:44 EDT 2007


On 05/30/2007 11:31:32 AM, Lacey Maryott wrote:
> Hey Karl,
>    According to the changelog, the invalid posture in this sample (R  
> *S* O S which should be R *2* O S) caused this particular line to be  
> deleted as per a rule made before about these types of conversion  
> errors.  It looks as thought this was the final conversion error  
> fixed on the date it was fixed, and it was a day Leah and I were  
> working together, which means it probably happened around 10-11 pm.  
> So, thinking we may have just forgotten to remove deleted rows... I  
> looked back in the latest DBF's I have here (updated may 23) and they  
> have the row in fpsamps, marked for deletion as well as the row in  
> fpneighbors which is not marked for deletion.  It's odd that this  
> didn't kick out an error on its own.

I'm not going to generate a conversion error because the
conversion program does not get those rows as data. :-P

  Tabby is going to keep the FP
> database until tomorrow and fix what she needed to fix, but once I  
> get it back, I can just remove the deleted row, and delete the  
> other.  However, I'm not sure why you are unable to pull up those  
> rows :-\

The FPSAMPS row I don't see because it's deleted.  The FPNEIGHBORS row
is a mystery.  The only thing I can think of is that the
fpneighbors.dbf on papio is different from what you've got.
Could that be?  I suppose there could always be a problem
related to indexes, somehow.  I don't really believe it but
there's some foxpro command or another (REINDEX maybe) that
rebuilds the indexes.

> If Leah used the version we have on our system here, it makes sense  
> that those rows would have shown up in the dump.
> I'm fearing this investigation uncovered more problems than it  
> fixed.. :-\

Maybe the problem is in the dump.  Did the dump come from you/Leah
or from Tabby?  Could be there's just fpneighbors that's out of sync.

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list