Update on Primary Key Field

A place for users and developers of the Xataface to discuss and receive support.

Update on Primary Key Field

Postby andperry » Thu Sep 22, 2011 2:56 pm

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.
andperry
 
Posts: 57
Joined: Wed Feb 18, 2009 9:20 am
Location: Wirral, UK

Re: Update on Primary Key Field

Postby shannah » Fri Sep 23, 2011 9:45 am

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?
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: Update on Primary Key Field

Postby andperry » Fri Sep 23, 2011 11:23 am

No it just does nothing, leaving the records unchanged.
andperry
 
Posts: 57
Joined: Wed Feb 18, 2009 9:20 am
Location: Wirral, UK


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 22 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved