Subject RE: [IBO] PessimisticLocking problem.
Author Claudio Valderrama C.
Help says you cannot use Pessimistic Locking with ServerAutocommit. If it
obvious if you understand how IB works.
Probably the message is misleading here.
The best thing you can do is to plan your application for optimistic locking
and only use pessimistic in very special scenarios. BTW, most C/S engines
have introduced optimistic locking recently.

C.

> -----Original Message-----
> From: Marco Carosi [mailto:marcoc@...]
> Sent: Sábado 3 de Marzo de 2001 12:50
>
> Hi,
> I have download IBO for evaluations and with it I have writhed a simple
> program, I want use the PessimisticLocking set to true, but when I try to
> edit a record the program generate a error:
>
> "Cannot use pessimistic locking with LockWait"
>
> This is my setting:
>
> Transaction.ServerAutoCommit:=True;
> Transaction.Isolation:=tiCommitted;
> Transaction.RecVersion:=False;
> Transaction.LockWait:=False; // *LockWait is false* !!!!!
>
> Query.Active:=False;
> Query.AutoFetchAll:=False;
> Query.AutoFetchFirst:=True;
> Query.AutoPostDelete:=True;
> Query.ColorScheme:=True;
> Query.FetchWholeRows:=False;
>
> Query.GetServerDefaults:=False;
> Query.IB_Connection:=Connection;
> Query.IB_Transaction:=Transaction;
> Query.PreventDeleting:=False;
> Query.RequestLive:=True;
> Query.PessimisticLocking:=True;
>
> Where I made the mistake ?
>
> Many thanks, Marco
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>