I have a 5.0 form that is composed of 2 blocks that each point to
a database table. It is your basic master-detail relationship.
I have encountered problems where users are entering
data on the detail table from other forms. This has caused
problems with updates in the master-detail form. I know this
is because the detail row is locked when an update is attempted
on the detail portion of the form. But forms doesn't seem to
correctly handle the answer to the "locked record" popup.
Should I include the FOR UPDATE clause on my detail blocks
where clause to prevent this? What event does the locked record
popup, invoke (not an exception or SQL%NOTFOUND I think)?
Click Here to Expand Forum to Full Width