Interbase only returns file space to the OS if you do a backup and restore.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Sandeep" <sandeep@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, May 16, 2001 1:38 PM
Subject: [IBO] Sweep


> The sweep function in Interbase doesn't seem to do anything. I had
> a table with 400000 records in it. I deleted all the records and did a
> sweep on the database. The database size didn't change a bit, I
> was expecting a reduction in database file size.
>
> Sandeep
>
> Software Developer
> CFL
> sandeep@...
> http://www.cfl.co.nz