You can either PACK the table and thus remove the record or RECALL the
deleted record
The problem occurs because VFP doesn't really delete records when you DELETE
them, it merly sets a flg on the record as deleted (and then filter it out
if SET DELETED is ON
setting UNIQUE will not matter this command affects REGULAR indexes and it
tells it to store only the first occurence of any key (it doesn't prevent
duplicate keys either btw)
>I have a table with a candidate key.
>When I append blank, and delete it, leaving the candidate key field blank.
>
>And when I try to append another blank record, the error msg
>" Uniqueness of Index feildname is violated "
>
>What can I do to overcome this problem?
>Should I set the UNIQUE OFF or ON in the form initialise event, will it
help?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement