main logo
Subject: Re: [V4RB] More ObjectPointer and index corruption woes...
Author: john roberts
Posted: 2001/05/30 14:48:42
 
View Entire Thread
New Search


on 05/30/2001 1:19 PM, Keith DeLong at delong /AT/ redcort .D.OT com wrote:

> I have new ObjectPointer and index corruption woes. While I do not yet have
> a simple project for you, I can repeat it with my complex project and
> describe the issue for you pretty well.
>
> In testing my compiled RB application, I delete 3 of 4 records of a very
> small test file.

Are you mixing bo methods and sql functions. If so, you might turn your bo
methods into function and test for completion before doing the sql.
>
> As a result of the deletion, another BO's objectptr field is properly zeroed
> due to the deletion control being SetNull.
>
> However, now doing a SELECT based on the BO's objectptr field returns
> incorrect results. (I'm looking for orphaned records).
>
> Trashing the index fixes the problem and selects now work properly again.

This would be consistent with what I experienced and what I mentioned above
cured it for me.

Best regards,
John Roberts

mailto:jarobe01@athena.louisville.edu


-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
 
©2001 john roberts
<-- Prior Message New Search Next Message -->