Hi all,

In a table i have a pair of primary key and when i tried to update record, exception is thrown

An exception was caught during the execution of an action query: Duplicate entry '5S-3880586-12331-KFL-850 ' for key 'PRIMARY'.

objDetailServisSpareSpart.IsNew = false;
                            objDetailServisSpareSpart.No = txtNo.Text;
                            objDetailServisSpareSpart.SparePartCode = gridLookUpSparePart.EditValue.ToString();
                             objDetailServisSpareSpart.Qty = objDetailServisSpareSpart.Qty +
                                                                   (int) txtQty.EditValue;
                            objDetailServisSpareSpart.Save();

The primary key are objDetailServisSpareSpart.No and objDetailServisSpareSpart.SparePartCode

I'm trying to change the qty

Check the SQL query that's being produced (enable tracing, see 'troubleshooting and debugging' in the docs)

please next time post in the right forum, thanks.

Sorry for post in wrong forum.

Check the SQL query that's being produced (enable tracing, see 'troubleshooting and debugging' in the docs)

I tried to read the docs but i didn't understand. I usually debug in VS.NET using standart debugging.

The only SQL Query i found on debugging is :

"\r\n\tQuery: UPDATE `detailservissukucadang` SET `JumlahSukuCadang`=@p1 WHERE ( ( `detailservissukucadang`.`KodeSukuCadang` = @p2 AND `detailservissukucadang`.`NomorNota` = @p3))\r\n\tParameter: @p1 : Int32. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 2.\r\n\tParameter: @p2 : AnsiString. Length: 30. Precision: 0. Scale: 0. Direction: Input. Value: \"12331-KFL-850 \".\r\n\tParameter: @p3 : AnsiString. Length: 10. Precision: 0. Scale: 0. Direction: Input. Value: \"5S-3880586\".\r\n"

As Otis said, please check "Troubleshooting & Debugging" in the docs. There you should know how to enable DQE tracing output. Then when debugging you should find the queries in the output window of VS.

Thanks Walaa for the reply.

I Think i know the problem.

Let me ask a new question : How to know whether the record was on the table or not?

I once used other ORM and it goes like this :

classItem objItem = new classItem();
objItem.Code = "A123";
objItem.Seek();

If (objItem.Rows > 0)
    //The Data was there
Else
    //The Data wasn't there

How about LLBLGEN ?

You will have to query the table for that record. Either by selecting a field, or by doing Count(). And anyway you'll have to filter on the PK.

You can also attempt to fetch the entity. Selfservicing: by creating a new instance passing the PK. Adapter: by using FetchNewEntity().

The solution to my question about multiple primary key update is to backup the database, drop it and then rebuild it with backup file.

Anyway, thanks for the help