Subject Question on deleting records and "packing"...
Author mlc29150
Hello everybody,

My question is may be trivial.

I'm using DELPHI 7 entreprise, with WinXP(Home edition), the very
good IBO 4.3, and Firebird 1.03(very good too).

I'm using an IBOQUERY to delete records from several table of a GDB
file.
My code is like this :

Procedure DELETE_RECORDS(Var MYTABLE : String);
Const INST_DELETE='DELETE FROM %s';
Begin
With IBOQUERY1 do
Begin
SQL.Clear;
SQL.Add(FORMAT(INST_DELETE,[MYTABLE]));
EXECSQL;
end;
END;

All is OK.

But before deleting, the GDB size is 5 MB. After deleting it's still
5MB...

The only one way I've found to reduce the size after deleting is to
do a backup of the GDB file...May be someone known another way to
reduce the size with something like the packTable method of Paradox ?


Thank's in advance for any response.
Best Regards,
Michel.