Re: Forms 4.5 Rollback 'POST'

Hiho.

Have you tried to Rollback your Postings explicitly with ISSUE_ROLLBACK ?
In this case you have to requery only the detail-block.

You could add this statements to a When-Clear-Block-Trigger in the detail-block.

Declare
  old_level VARCHAR2(2);
  ...
Begin
  ISSUE_ROLLBACK(NULL);
  old_level := :system.message_level;
  :system.message_level := '10';
 commit_form;
  :system.message_level := old_level;
  ...
End;

The commit_form does a pseudo-commit but u have to do it since the form does not realize that the Form-Status has changed (thats what it seems to me).
The message-level is raised in order to get no message that the form has been commited.

Greez,
Angelo.

-- 


-----------------------------------------------------------------

Angelo Cavallaro     /  /  /   \     TECTUM Beratungsgesellschaft
ORACLE-SW-Berater   /  /  /     \    für Informationsverarbeitung
ancavall.NOSPAM    /  /  /-------\   Tel: 0711/99073-10
_at_aol.com          /__/__/_________\  Fax: 0711/99073-99



-----------------------------------------------------------------

	 Visit the Home of the Green Ribbon Campaign:

		http://www.ponce.oisoft.com/



-----------------------------------------------------------------