Home » Developer & Programmer » Forms » HOW TO CAPTURE FRM-40350
HOW TO CAPTURE FRM-40350 [message #85915] Wed, 11 August 2004 05:05 Go to next message
domingo
Messages: 54
Registered: June 2004
Member
I have a NEW-BLOCK-INSTANCE trigger at block level and at the end of the code I am calling EXECUTE_QUERY built-in function. When there are no records in the base table then it is displaying "FRM-40350:Query caused no records to be retrived" on the message line. I want to change the message to "NO records found plzz try again with another no.', when EXECUTE_QUERY returns no data. Kindly elaborate as i am new to forms which trigger ti use and where the code shud be written.

Please guide me how can I accomplish this task. I appreciate in advance for your help.
Re: HOW TO CAPTURE FRM-40350 [message #85917 is a reply to message #85915] Wed, 11 August 2004 05:49 Go to previous messageGo to next message
omar
Messages: 19
Registered: February 2002
Junior Member
use on-message trigger on that block and put the following code in it

if MESSAGE_CODE = 40350 THEN
MESSAGE('NO records found plzz try again with another no.');
ELSE
MESSAGE(MESSAGE_TYPE||'-'||TO_CHAR(MESSAGE_CODE)||': '||ERROR_TEXT);
END IF;
Re: HOW TO CAPTURE FRM-40350 [message #86043 is a reply to message #85917] Tue, 24 August 2004 20:33 Go to previous messageGo to next message
Narendra K.
Messages: 18
Registered: June 2003
Junior Member
Dear Domingo,

Your code is well written, except in the else
statement the error_text should be replaced with
MESSAGE_TEXT.

if MESSAGE_CODE = 40350 THEN
MESSAGE('NO records found plzz try again with another no.');
ELSE
MESSAGE(MESSAGE_TYPE||'-'||TO_CHAR(MESSAGE_CODE)||': '||MESSAGE_TEXT);
END IF;

-Narendra
Re: HOW TO CAPTURE FRM-40350 [message #233181 is a reply to message #85915] Wed, 25 April 2007 02:27 Go to previous message
zergren
Messages: 2
Registered: May 2005
Junior Member
HI, I have found another case that will give error message frm-40350 when use view in block
Previous Topic: Form Generation at Unix Prompt
Next Topic: Detail Record Disappear
Goto Forum:
  


Current Time: Sat Dec 03 16:01:35 CST 2016

Total time taken to generate the page: 0.05105 seconds