Hi,

Newbie question:
I added a large number of records to a db making it's file size 20mb.
Then I delete all records, and size remains unchanged.

How does one therefore remove the stale records?

I need to achieve this via code, so is there a sql statement that can
do this or delphi component? (I'm using IBX atm. I don't mind using
other components but need them to be free).

Thank you,
Rael