>I had problem with a table's primary key.. I create a table and select a column (character 6 width) as a primary key to elimanate for duplicate entries.. but strangley I found out duplicates entries after one month.. how it happned.... i am using visual foxpro ver 5.0
>
>one thing more.. when i drop primary key and create the one again.. it showed me error..
>
>so please help me where did i make mistake..
>
>bye
>
>Zubair
Probably, your index got corrupted (perhaps by a computer crash), thereby allowing duplicate values. VFP will not create a primary (or candidate) key on a field if there are duplicate values. You will first need to manually edit the table and eliminate the duplication. Then re-create the key.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up