General information
Category:
Coding, syntax & commands
I'm having a little difficulty understanding how VFP treats deleted records. I understand that a deleted record is not removed from the table and is just marked for deletion. I was under the impression that if I "SET DELETED ON", I could code as if the records marked for deletion were not there.
I posted a similar question a little earlier but I didn't get a response. I have a table with 4 fields. zip_pk, zip_zipcode, zip_city and zip_st. 2 indexes Primary is zip_pk and a candidate zip_zipcode.
If I delete a particular zipcode and then try to recreate it I get a uniqueness violation. So I changed my base form class to put "SET DELETED ON" in the load event. This didn't do the trick. There has to be a way around this without issuing a pack? Isn't there?
sorry to be a nuisance
Paul
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only