>>I'm trying to get an server side ADO Recordset from an Oracle table with the LockType = adLockPessimistic, but it does not work. Can I not do this with Oracle?
>
>Also, word of warning. If another user has any one of the records you want locked, you will be in a wait state until the lock[s] is released. I know there is an additional clause to prevent this.
>
>FOR UPDATE NOWAIT
>
>I am at DevCon and I do not have my Oracle ref books, and I am not sure of the exact clause.


Thanks. When I used 'FOR UPDATE' in the Recordset Source I get no records being returned.