Forms4.5 question -- 2 users accessing the same row in table

From: Janice Powell <powell_at_clemson.edu>
Date: 1997/03/30
Message-ID: <5hmbht$km2$1_at_hubcap.clemson.edu>#1/1


[Quoted] [Quoted] We have an electronic forms routing application that allows one user to process a document and then send it on for approval. This application allows those in the approval process to view the document; thus, multiple users can view it simultaneously.
[Quoted] In testing, we have found that if one user is updating the document, the others who try to show it get a Forms4.5 "error" saying something like the data cannot be obtained, keep trying? You can click yes or no and then it appears to continue trying to query the data.

How can we avoid that situation? Do we issue some type of lock? Also, has anyone had a similar problem w/ accessing a sequence? If so, how did you handle that?  

Any info is greatly appreciated. Please send replies to powell_at_clemson.edu.  

Thanks.
--JP  

Janice Powell
Clemson Univ. Received on Sun Mar 30 1997 - 00:00:00 CET

Original text of this message