Problem with record locking

SweetPete · Post by **SweetPete** » Wed 25 Mar 2009 21:27

Dear Support,

I'm using Delphi 7, Firebird 2.1.1 and IBDAC 2.70.0.45.

I'm trying to get record locking working with the IBCTable component, but to no avail. However, the exact same property settings with IBCQuery enable record locking perfectly. The problem I'm experiencing is that even after user 1 posts their record, user 2 can't edit the same record because the program thinks the record edited by user 1 is still locked. Again, this problem doesn't occur with IBCQuery - when user 2 begins to edit any data in the record, the record is instantly refreshed with user 1's changes and user 2 can continue with their editing.

I've set the following relevant properties with both IBCQuery and IBCTable:

LockMode = lmLockImmediate
RefreshOptions.roAfterInsert = TRUE
RefreshOptions.roAfterUpdate = TRUE
RefreshOptions.roBeforeInsert = TRUE

Am I doing something wrong, or is this a bug?

Plash · Post by **Plash** » Thu 26 Mar 2009 08:30

We could not reproduce the problem. Please send to ibdac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.