>Hi -
>Has anyone ever deleted a record in VFP 6, and removed it all at the same time? The same as delete ---> pack , but all in one step
>
>If so please advise how, and does the file have to be opened excl.?
>
>Thanks in advance.
>
>Larry
PACK is quite slow, and not compatible with a multi-user environment.
The usual approach is to only DELETE, use SET DELETED ON to hide deleted records, and postpone the PACK for some moment when nobody is using the database. Since this is not very urgent, you can do it once a month, at midnight or something.
Some people - including me - have experimented with re-using deleted records, but that is quite involved, and not worth the trouble, IMO.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)