I believe that deleting a record from a dbisam table does not make the
file any smaller.  After deleting some 40% of the records in a table, is
there an easy way to compress the file?

Or else perhaps I should just use table;

opentable
create duplicate file
old.first
while not eof old do begin
  copy record from old to new
  next;
  end;
delete old
rename new

Something like that?
Jerry

"Jerry Blumenthal" <jerry@blumenthalsoftware.com> wrote in message
news:B364C7E8-0FE1-4D1B-8123-4C8986BA2FB9@news.elevatesoft.com...
>I believe that deleting a record from a dbisam table does not make the file
>any smaller.  After deleting some 40% of the records in a table, is there
>an easy way to compress the file?
>

Anything that will rebuild the data portion such as Optimize or repair.

Robert

Robert,

<< Anything that will rebuild the data portion such as Optimize or repair.
>>

Clarification: RepairTable won't compress the table and will leave the
deleted records "as-is", but Optimize will since it causes the table to be
copied into a new version, minus the deleted records.

--
Tim Young
Elevate Software
www.elevatesoft.com