Re: row-level locking question...

2003-11-19 Thread Heikki Tuuri
Andre, - Original Message - From: "Andre Charbonneau" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, November 17, 2003 5:11 PM Subject: row-level locking question... > Hi, > > Let say that I have the following transaction: > > 1. Read value v1 from table t1. > 2.

Re: row-level locking question...

2003-11-17 Thread Jeremy Zawodny
On Mon, Nov 17, 2003 at 10:10:52AM -0500, Andre Charbonneau wrote: > Hi, > > Let say that I have the following transaction: > > 1. Read value v1 from table t1. > 2. Do some computation using v1. > 3. Update value v2 from table t2. > > If in the above I don't want any other concurrent transaction