Hi,

I have written a very simple demo to see how the DMLCache works.

The demo works perfectly, however, when I set the IB_Query Property
PessimisticLcoking = True on one of the two IB_Query (or on both) and I try
to edit a single record (no other instance of the application or form is
currently editing the record in question) I get the following error:

ISC ERROR CODE: 335544569
ISC ERROR MESSAGE:
Dynamic SQL ERROR
SQL error code =-510
Cursor not updatable.

The demo consist of a single Form, IB_Connection, IB_Transaction, two
IB_Grids, each grid has a IB_Query, IB_DataSource and IB_UpdateBar
respectively.

The two IB_Queries are identical including the SQL and all its properties.


What have I done incorrectly?


I am trying to use the PessimisticLocking property so that a record can not
be in edited by various forms/grids at the same point in time.


Thank you

daniel