Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: OO4O and locking records in multiple dynasets

Re: OO4O and locking records in multiple dynasets

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 22 Dec 2004 23:10:11 +0100
Message-ID: <41c9f0ce$0$31576$626a14ce@news.free.fr>

"Eric Lepage" <nospam_at_ng.com> a écrit dans le message de news:P0myd.31173$oN3.1664493_at_weber.videotron.net...
| Hello,
|
| We're using OO4O 8.1.7.315
|
| Two ODynasets are connected to the same ODatabase. If both dynasets are
| issued a StartEdit() at some point, then performing an Update() in the
| second dynaset will release the lock in the first dynaset as well:
|
| ODynaset dyn1;
| ODynaset dyn2;
|
| ... connect, fetch records, etc.
|
| dyn2.Update(); // this release the lock in dyn1 as well
|
| Is there a global setting that can use to prevent this situation from
| happening? I know I can re-issue a StartEdit() on the first dynaset in a
| situation like the given example. But since the OO4O code is in a dll
| and this dll is accessed by multiple modeless windows, it is impossible
| to re-issue a StartEdit().
|
| Is it something that has been changed in later release of the OO4O library?
|
| Thanks,
|
| Eric Lepage
|

Use OSession.BeginTrans before Edit to avoid commit (and release of locks) on update and commit yourself your transaction with OSession.CommitTrans (or rollback with OSession.Rollback).

Regards
Michel Cadot Received on Wed Dec 22 2004 - 16:10:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US