Subject | Re[2]: [IBO] Locking rows |
---|---|
Author | Mark Pickersgill |
Post date | 2004-02-20T23:53:53Z |
Saturday, 21 February 2004, 9:51 AM
Hi Helen,
HB> The pessimistic lock does that. If IBO can't get the lock, it won't let
HB> the row go into Edit mode. You can catch the exception and use it to
HB> inform the user that someone else is working on it.
That's what I currently do, but I was wondering if there was a way to
not use pessimistic locking, but still give a similar message and
allow the operator to continue on and edit the record?
HB> OTOH, if you use the "quick transaction" approach with Read Committed and
HB> WAIT, there will be no exception if the later transaction has a higher
HB> transaction ID on the server. First to get the lock wins, others follow on
HB> in "hit order".
hmmm, I will have to sink my brain into this one, but right now it's
too hot here for that! :)
thanks
Mark
HB> Helen
HB> ___________________________________________________________________________
HB> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
HB> without the need for BDE, ODBC or any other layer.
HB> ___________________________________________________________________________
HB> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
HB> keyword-searchable FAQ, community code contributions and more !
HB> Yahoo! Groups Links
Hi Helen,
HB> The pessimistic lock does that. If IBO can't get the lock, it won't let
HB> the row go into Edit mode. You can catch the exception and use it to
HB> inform the user that someone else is working on it.
That's what I currently do, but I was wondering if there was a way to
not use pessimistic locking, but still give a similar message and
allow the operator to continue on and edit the record?
HB> OTOH, if you use the "quick transaction" approach with Read Committed and
HB> WAIT, there will be no exception if the later transaction has a higher
HB> transaction ID on the server. First to get the lock wins, others follow on
HB> in "hit order".
hmmm, I will have to sink my brain into this one, but right now it's
too hot here for that! :)
thanks
Mark
HB> Helen
HB> ___________________________________________________________________________
HB> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
HB> without the need for BDE, ODBC or any other layer.
HB> ___________________________________________________________________________
HB> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
HB> keyword-searchable FAQ, community code contributions and more !
HB> Yahoo! Groups Links