>I have a very general form for entering Instructor information. The table fields are Lastname, Firstname and Company. The index is Lastname+Firstname+Company and is set to primary. This is very handy because FoxPro detects if a duplicate already exists when adding a record which I trap in a Valid method.
>
>My problem though is like this.....I delete a record...oops wrong one...I try to add it back in....the record already exists error is triggered. I have SET DELETED ON and I've confirmed this in the debugger. Am I missing something or do I have to code a work around for this type of case. If the latter some examples would be greatly appreciated.
>
VFP is behaving correctly. Deleting a record does not remove it from the table or the index and thus can not be re-added as it will violate the primary key. Deleting simply marks a record as having a deleted status.
Now if you delete and PACK, then you can re-add as the record will be really gone from both the table and the index.
HTH