Home » Developer & Programmer » Forms » problem in rollback
problem in rollback [message #187720] Tue, 15 August 2006 02:54 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii All

i created a form that have a menu that contain a rollback button
when press on it , it should performs the action of rollback

but in this form when press on it, it clears the form from all the data on it

Thanks for everyone helped and helping me




Re: problem in rollback [message #187731 is a reply to message #187720] Tue, 15 August 2006 04:03 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I'm not wrong, this is expected behaviour of Oracle Forms when ROLLBACK is executed.
Re: problem in rollback [message #187733 is a reply to message #187720] Tue, 15 August 2006 04:42 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Do you mean that the action of rollback is clearing the block!!!!!!!!!!!!!!!!!
Re: problem in rollback [message #187781 is a reply to message #187733] Tue, 15 August 2006 10:24 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Actually, I believe that Oracle doesn't care too much what I think about it. This is what Oracle documentation says about the issue:
Oracle

If you use a PL/SQL ROLLBACK statement (...), Form Builder interprets that statement as a CLEAR_FORM built-in subprogram with no parameters.
Re: problem in rollback [message #187862 is a reply to message #187720] Wed, 16 August 2006 01:15 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

then how can i solve this problem

by the way i made a code for Rollback

CLEAR_BLOCK(NO_VALIDATE);
CLEAR_RECORD;
ROLLBACK;


it works fine for all forms except this form
in this form it clear the block
i don't why
Re: problem in rollback [message #187877 is a reply to message #187720] Wed, 16 August 2006 03:11 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I use ISSUE_ROLLBACK(NULL);
Re: problem in rollback [message #188134 is a reply to message #187862] Thu, 17 August 2006 04:12 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I assume you will have to go to your main block and do an execute-query.

David
Re: problem in rollback [message #650826 is a reply to message #187877] Wed, 04 May 2016 12:40 Go to previous messageGo to next message
bahubcd
Messages: 40
Registered: July 2007
Location: Bangalore
Member
@wency, ISSUE_ROLLBACK(NULL); works to rollback.

Thanks.
Bahubcd
Re: problem in rollback [message #650833 is a reply to message #650826] Wed, 04 May 2016 19:46 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I doubt that Wency has been waiting a DECADE for your words of wisdom.
Previous Topic: progress bar(necessary)
Next Topic: 11g Forms
Goto Forum:
  


Current Time: Fri Mar 29 07:52:36 CDT 2024