How to do pessimistic locking in oracle with vb4

From: Eric Leblanc <infosile_at_generation.net>
Date: 1996/11/15
Message-ID: <328C8BC2.57D7_at_generation.net>#1/1

I'm accessing an oracle 7.1 database in vb4, using an openlink lite driver. I use a resultset to do some editing on a table. When a user edit a record, I want this record to be locked, so the other users can't modify this record. I tried to open my resultset with the rdConcurLock locktype, but I received the error :
S1C00 : [Microsoft][ODBC Cursor Library] Cursor library not capable

Is there any other way I can do this? Received on Fri Nov 15 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Rakesh Patel: "Calling 'C' routine from PL/SQL"
Previous message: Gollapalli Joseph: "Help installing personal"
Next in thread: Dave Lindquist: "Re: How to do pessimistic locking in oracle with vb4"
Reply: Dave Lindquist: "Re: How to do pessimistic locking in oracle with vb4"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message