Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread LockTable
Mon, Sep 3 2007 10:23 AMPermanent Link

I have a table. My code calls LockTable and I stop in a breakpoint before
the UnlockTable. Should I still be able to edit the table in dbsys? I can
edit fields during this state even though I feel I shouldn't be able to.
Or is the IDE doing something clever. FWIW, the app is a RemObject server
so has a datamodule with auto-named session. I just expected the table to
be locked against editing - the manual implies this is the case. What am I
missing?

/Matthew Jones/
Tue, Sep 4 2007 9:20 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Matthew,

<< I have a table. My code calls LockTable and I stop in a breakpoint before
the UnlockTable. Should I still be able to edit the table in dbsys? I can
edit fields during this state even though I feel I shouldn't be able to. >>

If you can still edit any row in the table after another session has called
LockTable, then you most likely are using a different table.  I just tried
it here with the latest 4.25 and LockTable definitely locks every row in the
table.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Sep 4 2007 9:47 AMPermanent Link

"Robert"

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:1C2CC1E5-E653-4C2A-8DA1-0352081D8706@news.elevatesoft.com...
>
> If you can still edit any row in the table after another session has
> called LockTable, then you most likely are using a different table.  I
> just tried it here with the latest 4.25 and LockTable definitely locks
> every row in the table.
>

Will a locked table be backed up?

Robert

Tue, Sep 4 2007 10:26 AMPermanent Link

I feared you'd say that. I'll investigate further.

/Matthew Jones/
Wed, Sep 5 2007 2:34 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Robert,

<< Will a locked table be backed up? >>

Yes.  Backups and transactions/posts use a different level of locking from
that of row and table locks.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image