Subject | Question on deleting records and "packing"... |
---|---|
Author | mlc29150 |
Post date | 2004-01-19T14:47:59Z |
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.
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.