🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac
Article #27499

Recovering space from Reflex DBMS

#27499
From: Byron Weber Becker
Date: Tue, 26 Apr 1988 00:50
30 lines
1552 bytes
How do I recover space from Reflex?

I have deleted about 70k of records from a database created by 
Borland's Reflex DBMS.  I now need to recover the actual disk space.  It
seems that Reflex does not physically delete the records (it only marks
them as deleted) and I have found no way to make the file smaller.

Things I have tried:
-- The "Save As..." option.
-- Exporting the records, deleting them all and then importing them again.
-- Some primitive hacks:
   -- Use ResEdit to copy the resources defining the input screen, etc. to
      a new file.  It coughs with error -39 (End of File) when opening
      the file.
   -- Resetting the logical end of file with FEdit.  The finder showed
      no change in the file size.  Making a copy of the file didn't help
      either.

The only solution I have been able to come up with is to export all
the records and then import them into a brand-new file that is identical
to the one they came from.  I don't want to do this because it is a lot
of work to redefine all the fields in the file and the input screen.

Any suggestions?  All I want is the disk space back from the deleted
records.

Thanks,

Byron Weber Becker
Technical Details
Message-ID: <6548@watdragon.waterloo.edu>
Path: arc1-ca.pugleaf.net!utzoo!utgpu!water!watmath!watdragon!violet!bwbecker

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!water!watmath!watdragon!violet!bwbecker
From: bwbecker@violet.waterloo.edu (Byron Weber Becker)
Newsgroups: comp.sys.mac
Subject: Recovering space from Reflex DBMS
Keywords: Reflex
Message-ID: <6548@watdragon.waterloo.edu>
Date: 26 Apr 88 00:50:37 GMT
Sender: daemon@watdragon.waterloo.edu
Distribution: na
Lines: 30