Plz Help me

Dear Sir,
Hello
I am a learner watching your profile led me to this that u would kindly resolve my problem asap.
It goes like:
"The changes u requested to the table were not successful because they would create duplicate values in the index, primary key or relationship. Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permit duplicate entries and try again."
When making an entry at runtime.
Dear Sir, I am just new to this programming and plz treat me as a layman.

Thanks Sir.
[575 byte] By [amartyat] at [2007-11-20 1:21:51]
# 1 Re: Plz Help me
You try to insert a duplicate value in a field with primary key or unique index defined on.
for example..If you have ID column your table and try to insert the same value twice in this column (two (5)s for example) You'll get this error..The same for unique index.
change the value or change the index to allow duplicates as the message suggests.
Send us more details (the table structure/the type of DB you use) if my reply is not helpful enough.
hspc at 2007-11-9 13:44:12 >
# 2 Re: Plz Help me
The contraints on your existing tables are getting invalidated due to the work that you are trying to do. There would be some problem with the data that you are inserting.. Can you show the query that you are trying to execute and the relevant db name and schema as hspc asks?
exterminator at 2007-11-9 13:45:12 >