Raj
To pack a table, yet retain the deleted records, is a contradiction in terms. If you need the ability to "recall" those records at a later date why not archive them to another table, then pack. e.g.
Select myHugeTable
Copy to ARCHIVEx for DELETED()
Pack
Then the archive table can be used to recall records. Of course, if you do this several times, and you want to keep the archive indefinitely,then you'll need to have a dynamic archive table name.
Terry
>We are Using Visual foxpro 6.0
>
>And want to pack a table which has 158,000 records in it, but the size is too awful it is 1.5 GB (Altogether .dbf, .cdx, .fpt)
>
>I want to pack the table but the thing is it has lot of deleted records, i don't want to remove those records permanently from table.
>
>The reason is we have a function in the form's to recall the deleted records.
>
>Please let me know Thank you very much.
>
>-Raj
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.