Do Part Number and Manufacturer form a composite key--Java API

[Former Member]

How can i make a search for records having same part No.

How do i avoid inserting duplicates.Display exact error.

I am using mdme Java Api.I hope u will help me quikly.

Thanx & Regards

Narayan

[Former Member]

Using the MDM Console, you can specify which field (or combination of fields) comprise a unique key for that table.

If you then try to add a record via the API which fails the uniqueness constraint, the API will throw an exception which you can catch in try/catch block.

[Former Member]

Thanks Walter.

[Former Member]

> How can i make a search for records having same part

> No.

Only in a loop one by one. If it's not unique such records can exist there. Actually you should have checked it when were inserting/creating them.

> How do i avoid inserting duplicates.Display exact

> error.

Check before inserting whether such a record exists or not.

> I am using mdme Java Api.I hope u will help me

> quikly.

> Thanx & Regards

> Narayan

[Former Member]

Thanks Roman.