Hi all
I've got quite a simple question, but i've struggled to find any help whilst googling the net, so I'm assuming the solution is not a simple one.
I'm using delphi 7 with interbase. I'm using transaction control and not cached updates. I'm using an optomistic read-only lock on a record with my transaction control. So one person might open a record for updating, another can view the record but if he tries to change that record he received a "locked, no wait transaction (or something to that affect". My problem is, I would like to be able to tell as a user opens a record whether it is being locked by someone else, and warn him that no updates can be done to the record until the person currently editing it has posted his changes (commit) and therefore released the lock. What would also be great is if I could somehow tell which person has the record locked, but it's not vital.
Thanks for all the great posts!
Cyberant
I've got quite a simple question, but i've struggled to find any help whilst googling the net, so I'm assuming the solution is not a simple one.
I'm using delphi 7 with interbase. I'm using transaction control and not cached updates. I'm using an optomistic read-only lock on a record with my transaction control. So one person might open a record for updating, another can view the record but if he tries to change that record he received a "locked, no wait transaction (or something to that affect". My problem is, I would like to be able to tell as a user opens a record whether it is being locked by someone else, and warn him that no updates can be done to the record until the person currently editing it has posted his changes (commit) and therefore released the lock. What would also be great is if I could somehow tell which person has the record locked, but it's not vital.
Thanks for all the great posts!
Cyberant