How to avoid collisions in a multi user environment usung form grid

[rafi farchi]

Hi

In a multi user environment , it is possible that 2 users are accessing the database using the wizard form grid

or form smart grid  . Suppose that the 2 users open in the edit window the same row .

How a collision can be avoided ? That means i would like the a user will be blocked for update if

the data presented to him on the edit mode is no more fresh .

for example in Oracle Application Framework(OAF) the update will be blocked with the message that

the data is stale .

Thanks

Rafi Farchi