I also thought so, but I was not quite sure. If I wrote APPEND BLANK plus DELETE plus PACK then my solution also would be three lines, and no gain. :-)
>Hi Tore,
>
>It's only true if a table has deleted records, otherwise PACK will do nothing.
>
>>
>>even easier is PACK because pack internally does more or less the same as you do with your three commands.
>>
>>>Hi Nuno,
>>>
>>>Don't care that. Until VFP8, VFP don't check file size of DBF file. Since VFP8, VFP checks .DBF file sizes.
>>>
>>>You can do that:
>>>set table vali to 0
>>> rena mydbf.dbf to mydbf.bak
>>> use mydbf.bak
>>> copy to mydbf
>>>
>>>after that you will see the file won't give that error. Because this process fix table size.