Referential Integrity (SOLVED)

Jan 28, 2013 at 9:27 AM

Since there appears to be no primary key except the id generated internally, is there any built in way to avoid duplicate data?

It appears that you can insert the same object as many times as you like.

I guess I'm asking if there is a way to set a different primary key?

Coordinator
Jan 29, 2013 at 7:12 AM

Hello,

you can use unique index to address that. The purpose of db is to save objects, so you are managing of what and when will be stored in db. If you want to update something, you always need firstly to query for this object, and then store it.

Jacek