Re: Forms4.5 row locking

I would use the debugger and step through your form. My guess is that some other trigger is modifying a database field.

Steve Cosner (stevec_at_zimmer.CSUFresno.EDU) wrote:
:> 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

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.