Subject | PessimisticLocking problem. |
---|---|
Author | Marco Carosi |
Post date | 2001-03-03T16:50:21Z |
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
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