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 |