I have two sessions of my app running. In the first one, I have
started a transaction and have read a row for editing. In the second
one, I then try the same. An error 109 (Record is in use by another
user.) is thrown. This is what I expected.

To figure out how things work, I then retry. As far as I can
tell, the error should happen again (and again and again). It does
not. In fact, if I proceed to change the row and save, the changes
take! This is in spite of the fact that the other session started a
transaction and has touched that record. My understanding is that the
record should be inaccessible to the second session while the first
session has a transaction open.

Yes, I do have the tables in a .dbc.

What is actually going on, please?

Sincerely,

Gene Wirchenko

On Wed, 21 Sep 2005 16:43:24 -0700, Gene Wirchenko
<genew (AT) ucantrade (DOT) com.NOTHERE> wrote:

To clarify, at this point, the first session has not changed the
record.

Sincerely,

Gene Wirchenko