Re: update with where clause constraints?

2010-02-06 Thread Karen Tracey
On Sat, Feb 6, 2010 at 8:55 AM, Malcolm Box wrote: > 2010/2/5 Jared Smith > >> My use case is that I'll have multiple users trying to update a set of >> objects and I want to make sure that any user committing a change has >> knowledge of the existing state. I was going to model that with a ver

Re: update with where clause constraints?

2010-02-06 Thread Malcolm Box
2010/2/5 Jared Smith > My use case is that I'll have multiple users trying to update a set of > objects and I want to make sure that any user committing a change has > knowledge of the existing state. I was going to model that with a version > number so an update would look like: > Maybe I'm mi

Re: update with where clause constraints?

2010-02-04 Thread Karen Tracey
On Thu, Feb 4, 2010 at 8:08 PM, Jared Smith wrote: > My use case is that I'll have multiple users trying to update a set of > objects and I want to make sure that any user committing a change has > knowledge of the existing state. I was going to model that with a version > number so an update wo

update with where clause constraints?

2010-02-04 Thread Jared Smith
My use case is that I'll have multiple users trying to update a set of objects and I want to make sure that any user committing a change has knowledge of the existing state. I was going to model that with a version number so an update would look like: update table set col=foo, col1=bar where id=p