Re: VB6 - ADO - Oracle Problem

>Is there any way that I can lock rows from my recordset till I update them
>succesfuly or I only should be satisfied knowing that someone else has
>updated the same rows after I read them?

You have to:

1. rs.begintrans
2. select * from tab where ....    for update nowait
3. commit or rollback

The 'for update nowait' locks the rs
until rollback or commit.

Good luck,
Tim Received on Wed Dec 01 1999 - 21:26:07 CST