Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Pessimistic lock on Oracle table
Message
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00420777
Message ID:
00422106
Views:
11
>>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?
>
>As a side note, in a multiuser application you should avoid the use of server side cursors for updating data because of server overload.

Thanks. This app runs multiple sessions of itself unattended. I need to lock records to ensure that the each record is only processed once.
George
Previous
Reply
Map
View

Click here to load this message in the networking platform