>Has anyone seen this behavior?
>
>
>I have a CANDIADTE KEY on a customer table called cust_id
>
>if I delete it, and set deleted on VFP3 still takes it into account when
>appending new records and I always get the great message
>
>INDEX KEY VIOLATED....
>
>Does anyone know why? or how to fix it or get around it?
this is not really strange and quite expected actually
when you delete a record in VFP it is not erased from the table (until you
PACK or something like that)
and basically you can RECALL that record
this is why you can't have a new key with the same value..
this is also one way of solving your problem by recycling the deleted
record with the new values..
Arnon
Previous
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