Be easier if you email me the sample app to rohit@...

----- Original Message -----
From: "Don Schoeman" <don@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, 21 February 2002 2:56 AM
Subject: [IBO] Pessimistic record locking


> I'm trying to get the pessimistic record locking scheme to work using IBO.
> I'm testing this functionality by running two instances of my test
> application with the PessimisticLocking property set to true for the query
> (TIB_Query). I'm also setting it's LockWait property to false just in case
> it could influence the test.
>
> Here are the steps I'm taking to perform this test:
> 1) I start editing a record in the first instance of the application.
> 2) While keeping the dataset in it's edit state I switch to the second
> application and start editing the same record.
> 3) The second application allows me to edit the record without throwing
any
> exceptions.
> 4) I commit the transaction in the second application and it still doesn't
> give me any errors.
> 5) When I switch back to the first application and try to commit the
> transaction it then gives me a lock conflict error. (Obviously because the
> LockWait property is set to True).
>
> Through this test I can see that the pessimistic locking scheme is
> completely ignored. Could anyone give any help? I'm using IBO 4.2.Eg with
> Interbase 6.01.
>
>
> Best Regards,
> Don Schoeman
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
___________________________________________________________________________
> 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 !
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>