🚀 go-pugleaf

You can explicitly lock records in Oracle by adding:
"FOR UPDATE NOWAIT"
to the end of the SELECT statement.  This will throw an
Exception if the selected record is locked and you can decode
the ORA error code from there.

- Arnie

"F. Schmitt" <fs@sonik.de> wrote in message news:3b84e222_2@dnews...
> Hi there,
>
> I use Microsoft OLE DB Provider for Oracle with AdoExpress,
> and want to get the user a message like "record is being edited by another
> user", best case
> when (before) the user tries to edit a record.
> I now tried nearly all possibilities on LockType, (Conenction)Mode,
> CursorType, ...
> the only error I get is "record to be updated couldn't be found" due to
the
> other user modified some fields. But I get this error only when posting my
> changes.
> I also tried all those settings with the Oracle OLE DB driver, but without
> change.
>
> Can anyone tell how to use Pessimistic Locking? Most settings I change to
> the ADOConnection or my ADOQuery are set back to default or other unusable
> values.
>
> Thanks,
>
> F. Schmitt
>