Re: How to gain excluisve lock with VB6/ ADO/ Oracle

do:

1. begin trans
2. select * from tab where x = value for update nowait
3. commit (or rollback)

>Hi all,
>Can anybody tell me how to gain an excluisve lock on a record with VB6, ADO,
>Oracle on NT? My understanding is that I cannot use adlockpessimistic with
>Oracle OLE DB provider. Maybe there is some other way of doing it.
>
>Please help!!!
>
>Ling
>
>
Received on Tue Jul 25 2000 - 00:00:00 CEST