Hi Daniel,

had you set RequestLive to True?

Greetings
Dirk

> -----Ursprüngliche Nachricht-----
> Von: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Im
> Auftrag von Daniel R. Jimenez
> Gesendet: Dienstag, 14. Juni 2005 04:18
> An: IBObjects@yahoogroups.com
> Betreff: [IBO] PessimisticLocking Question
>
>
> 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
>
>
>
>
> _________________________________________________________________________
> __
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> _________________________________________________________________________
> __
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

__________________________________
Die E-Mail wurde auf Viren überprüft
AVK MailGateway für MS Exchange Server
RCS GmbH Finsterwalde/Massen
Version: AVK 15.0.5419 vom 11.06.2005
Virus news: www.antiviruslab.com