V4RB - DEFRAGMENT after deletion of records

[Ruslan Zasukhin]

On 9/24/05 5:03 PM, "RB User" <fitzbew at nc.rr.com> wrote:

> I can't diagnose the db after I get the -39 error.  I can't open the db.
> 
> I can defrag (or compress) *any* database I want as long as I have NOT
> deleted any records.  The db works fine afterwards.
> 
> Or, I can delete records and NOT defrag and the DB works fine subsequently.
> 
> It is the act of of deleting all the records in a table and then defragging
> which corrupts(?) the database.  (I hesitate to say "corrupt" because I do
> not precisely know what is happening. All I can say is that Mac OS throws a
> -39 error when I try to open the DB.)

What about next sequence?

    - delete 
    - close
    - open 
    - defragment
    - diagnose
    - close 
    - open ?

 
> Yes, I have created "fresh" database files from earlier XML files and they
> work fine until I delete records AND do a defrag.
> 
> I was hoping for some method/workaround in a 1.10 environment that would
> enable me to reclaim empty segments (as if I was doing a defrag) even though
> I had deleted records.

So you use 1.10 ?

Even not 1.11 ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]