Forms4.5 row locking
Date: 1995/12/06
Message-ID: <DJ6IH5.1E9_at_CSUFresno.EDU>#1/1
I have a form which has a base-table block, and in the block, there is
a non-base-table item. In a post-query trigger, the non-base-table
item value is set. This causes the form to mark the row as changed,
and locks the row in the database.
This process prevents any other users from using the same form with
the same data.
Am I missing something obvious? What is the "right way" to accomplish
this? Until the user actually changes an item from the base-table,
I don't want the row locked.
(We can work around it by setting up another block with the
non-base-table items, but this requires a bit of extra work to keep
both blocks in sync by row.)
Are there some item properties on the non-base-table item to set to
keep the form from locking the row?
Please, anybody with some hints on this, could you pass them along?
TIA,
Steve Cosner
Received on Wed Dec 06 1995 - 00:00:00 CET