Re: updating the primary key of a table row

2006-05-17 Thread Abid Hussain
Hi Armin, For this special case you have to delete the old value/obj and then insert the new vale/obj. regards, Armin thanks a lot. I thought of this possibility, but wondered if there is another way to perform the update. Regards, Abid -- Abid Hussain Mail: [EMAIL PROTECTED] Web: http

Re: updating the primary key of a table row

2006-05-16 Thread Armin Waibel
Hi Abid, Abid Hussain wrote: Hi everybody, i wonder how to perform an update on a table where i changed the primary key. You can't change a PK value in OJB and at least OJB needs one PK field. Let's say i've got a table, where the only unique column is the primary key itself - like this:

updating the primary key of a table row

2006-05-12 Thread Abid Hussain
Hi everybody, i wonder how to perform an update on a table where i changed the primary key. Let's say i've got a table, where the only unique column is the primary key itself - like this: CREATE TABLE foo ( foo_name VARCHAR PRIMARY KEY ); Now I change the column foo_name of a row f