Powerbuilder Error

[margami]

Hi everyone, can someone help me with my problem. I got an error message when i save the data i entered, this is the message:

SQLSTATE=23000[MERANT][ODBC Sybase ASE Driver][SQL Server]Attemp to insert duplicate key row in object 'TBL_DTL_MHR_PAYMENT' with unique index 'TBL_DTL_MH_15005293482'..

Thanks.

 

[mbalent]

You are trying to insert a row in the database that contains data which is already in the database. You need to check the index 'TBL_DTL_MH_15....' to determine which columns in the table it contains and then look in the database for a record which already has the values you are trying to insert. It may just be the Key value in which case you need to designate a new key value for the new row.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[margami]

Thanks for the reply @mbalent...How can i check the index 'TBL_DTL_MH_... i right click on that index but the options are only drop index and properties. How can i check it? Thanks.

 

[mbalent]

The properties should show you what columns are used in the index. With that information you can check the database for records with those columns the same as the new record you are trying to insert.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[margami]

I already checked the properties in the index, but their is no column declared twice or have the same name.