Re: Partial Commit Handling?

Hi,

Although the record is not hidden from other users, in Forms 4.5 as soon as the user keys anything into a base table item, then a lock is taken out on that row. Given this, a second user who attempts to make changes to the same row will be notified and prevented from changing that row.

The vital thing is that during the time from the first key stroke of the user making the change to the point of commit or rollback of that change, then other users are prevented from changing that row and the changes being made are private to the user making the change. All of which is critical in a multi-user environment if read-consistency is to be maintained.

Depending on the total application, is hiding the right answer? In many scenarios hiding rows that are being worked on by others would be immensely confusing as a user would never know whether an item was hidden or missing.

In one application I worked on recently, I used an on-lock trigger to flag an intermediate table that a change was in progress, so that other users querying the flagged item were notified on their screens that some-one somewhere else was changing that item and they were then tidyly prevented from making changes themselves. However, it can get messy as you obviously have to commit the flagging whilst maintaining the ability of the user making the change to rollback transparently and for the changes they are making to be transparent to other users.

Hope its helpful,

regards

Rod Corderey
Lane Associates
Lane_Associates_at_Compuserve.com
http://www.Lane-Associates.com  

YyWong wrote:
>
> I am writing a stock queue program such that users can retrieve the
> designed item from the stock in first-in-first-out pattern.
> Suppose a user select an item from the queue and do some preparation
> such as typing "description" before commiting it. However, another
> users in other sessions can also see the "reserved" item.
>
> Therefore, my question is:
> Are there any function in forms 4.5 or Oracle Database that can
> "hid" the record once a user select it from the queue but not
> commit yet?
>
> Thanks in Advance!
Received on Sun May 03 1998 - 09:43:04 CEST