Re: How do I lock a record in Delphi/Oracle

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 9 Jun 1999 09:26:33 +0200
Message-ID: <7jl4r4$337$1@news3.saix.net>

Trond Ronde wrote in message ...
>How do I lock a record with Delphi ?,
>I'm using a TQuery component together with ODBC -> ORACLE 8
>I know I can use:
> 'SELECT * FROM xxx 'WHERE yyy = 'zzz'' FOR UPDATE'
> but I only get an "Capability not supported" when I try

Methinks that the problem is with the ODBC driver. I have just tried the 'FOR UPDATE' clause using native Oracle/BDE with Delphi 4 and it works fine.

IMHO stay away from ODBC when you're thinking of doing any serious client server stuff.

regards,
Billy Received on Wed Jun 09 1999 - 02:26:33 CDT