>Hi all,
>
>I have a problem about deletion. I delete a record first and then I add this (same) record again. then the index rule is violated. I cann't pack the record in my program as someone else is using. as i just can logical delete now, i cann't add this record again. Can vfp6.0 support sql that is physical delete? thax.
>
>Linda

You can either has filtered index with not deleted() in filter condition or don't re-use the same key - this is preferable...