>Hi, i've been using a table with a primary index key. After a while, i`m getting a message of uniqueness of index has been violated.
>
>Is it because i could have a bad coding or is it a problem with VfoxPro5.0 ?
The message indicates that you're trying to add records with the same primary key as an existing record in the file, or alter the primary key of an existing record in the file to be the same as another primary key.
If you're using APPEND BLANK to add records to the table, you'll get this error when two BLANK records are being added to the table at the same time, whether by the same person or by two different people. Using INSERT rather than APPEND BLANK...REPLACE avoids this problem neatly.
>
>Thanks for your attention.
>
>One day, i'll be good (hopefully).