[Zope-dev] time stamp - concurrent editing

[Nai A. Tzeo]

Hello,

I'm a zope newbie and was wondering if anyone on the list know how to solve
the problem of concurrent editing.  I'm using zope as a front end and SQL
server as a back end.  Basically, I want to be able to edit a record with
out having to lock the record so that others can use it but I want to make
sure that when I update and save my changes that I don't overwrite someone
elses changes.  I was thinking about time stamping the record every time a
person grabs the records in update view.  Before the changes are written to
the database, the timestamps on both the record that's checked out and the
record that was modified should be compare.  If the timestamp in the
database is more recent, meaning someone has updated the record, then I
can't update the record with my changes.  I would need to grab the latest
copy from the database and add in my changes.  I know this sounds really
inefficient but I can't think of another way.  If anyone have other ideas or
thoughts, pass it along.  It will be greatly appreciated.

TIA,
Nai