I'm not 100% certain, but I'm pretty sure that the Village API does not allow the update of primary keys. At least I think I recall someone mentioning that on this or the Torque list.
I'd also say that updating the keys is probably a bad idea anyway. Can you refactor the schema? It sounds like you might benefit from redesigning the schema to better suit these needs. The other option would be to write a method(s) to do what you need via a manually established connection. On Thu, 2003-04-03 at 11:08, Mark Lybarger wrote: > i'm using tdk 2.2 with the torque om. i'm having troubles doing updates to > the primary key of my records. The message I get is: > The value for column 'SCORECARD_TYPE' is a key value and cannot be updated. > > I'm using the .doUpdate( selectCriteria, updateCriteria) method to attempt > the update. This table has a 4 part primary key, and the user wishes to > update some / all of the primary key fields. any suggestions? > > Mark Lybarger > [EMAIL PROTECTED] > CBC Companies > 614.442.3741 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.463 / Virus Database: 262 - Release Date: 3/17/2003 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
