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. R
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
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 to read v2
until I'm done updating it, how should I put an exclusive lock on it?
Us