Home » Developer & Programmer » Forms » can i suppress this message "DO YOU WANT TO SAVE THE CHANGES THAT U HAVE MADE"
can i suppress this message "DO YOU WANT TO SAVE THE CHANGES THAT U HAVE MADE" [message #133617] Sat, 20 August 2005 03:09 Go to next message
ashraf_arif59
Messages: 35
Registered: March 2005
Location: Pakistan
Member

can i suppress this message "DO YOU WANT TO SAVE THE CHANGES THAT U HAVE MADE"
Re: can i suppress this message "DO YOU WANT TO SAVE THE CHANGES THAT U HAVE MADE" [message #133622 is a reply to message #133617] Sat, 20 August 2005 04:56 Go to previous message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

you can give ur user defined message also instead of this.

write commit with no_validate option
and write in the form level trigger
on-error trigger following :
IF ERROR_CODE IN (40400,40401) THEN
MESSAGE('VOUCHER SAVED');
MESSAGE('VOUCHER SAVED');
END IF;
on-message trigger following :
IF ERROR_CODE IN (40400,40401) THEN
MESSAGE('VOUCHER SAVED');
MESSAGE('VOUCHER SAVED');
END IF;
Previous Topic: Can I use commit at block level
Next Topic: Displaying the records only
Goto Forum:
  


Current Time: Fri Sep 20 12:21:47 CDT 2024