Page 1 of 1

Update on Primary Key Field

PostPosted: Thu Sep 22, 2011 2:56 pm
by andperry
Tried doing a multi-record update on a primary key field. Might at first sound an odd thing to be doing, but the scenario was a table where the primary key spanned three record fields. Was trying to do a bulk update on a group of records where one of the primary key fields shared a common value. It didn't seem to work - records not updated. Not a big deal however as I was able to achieve the desired result by doing a copy followed by a delete. Even so, just wondered whether that it how it is meant to be, or is there a problem?

Thanks,

Andrew Perry.

Re: Update on Primary Key Field

PostPosted: Fri Sep 23, 2011 9:45 am
by shannah
Not sure why this would fail. I've added a bug report. I generally don't use compound primary keys so I haven't run across this issue.
http://bugs.weblite.ca/view.php?id=839

Did it report an error message?

Re: Update on Primary Key Field

PostPosted: Fri Sep 23, 2011 11:23 am
by andperry
No it just does nothing, leaving the records unchanged.