OraFAQ Forum: Forms » commit_form Success or Not

Home » Developer & Programmer » Forms » commit_form Success or Not

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

commit_form Success or Not [message #81076]

Fri, 03 January 2003 10:42

Tyler
Messages: 123
Registered: January 2002

Senior Member

Hello All,

I am trying to use COMMIT_FORM;
then using IF FORM_SUCCESS THEN -- message (success)
else -- message (no_save).
But it seems to be saying success even if it isn't actually saved???
SUggestions?

Thanks,
T

Report message to a moderator

Re: commit_form Success or Not [message #81085 is a reply to message #81076]

Sat, 04 January 2003 05:14

Anu
Messages: 82
Registered: May 2000

Member

Hi
This problem has been encountered by me also.
So I suggest that you try 'SYSTEM.FORM_STATUS' instead of 'FORM_SUCCESS'. i.e you can use the following code:

commit_form;
IF :system.form_status = 'QUERY' THEN
message('record saved');
ELSE
message('record not saved');
END IF;

Report message to a moderator

Previous Topic:	genarate spool file through D2K form
Next Topic:	CREATE_RECORD (changed status instead of insert)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 23:12:07 CST 2025