Re: Forms 4.5 Problem (Record Locking)

[Quoted] Apparently you are executing a commit in your code. This is non-standard behavior.
Try reproducing this behavior on a newly generated form without code and [Quoted] you'll see it won't happen. If this truly was a bug, it would have been [Quoted] ironed out long ago.

Hth,

Sybrand Bakker, Oracle DBA

<pol15_at_my-deja.com> schreef in berichtnieuws 8dh754$v49$1_at_nnrp1.deja.com...
> Hi all,
>
> I have encountered a problem in Oracle Forms 4.5 with regard to record
> locking.
>
> If I update a record using a Form developed in Forms 4.5, and I move on
> to another record without choosing the "Save" option (ie. post a commit
> to the database), then a
> default Oracle dialog appears saying ...
>
> "Do you wish to save the changes you have made?"
>
> If I answer "No" to this dialog box, then the record that was changed
> is not released for other users to update. It is still locked, as if a
> "rollback" has not beed executed. The reason I know the record remains
> locked is that, when I use the same Form in another session, a "Could
> not reserve record" dialog appears.
>
> The only way to release the record is to hit the "Save" button (ie.
> post a commit to the database) or for the user to quit the Form.
>
> Is this a bug?
>
> Surely the record should be released if the answer is "No" to the above
> dialog box.
>
> Does anyone know a way round this problem.
>
> Any help greatly appreciated.
>
> Pol
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 18 2000 - 16:35:08 CEST