OraFAQ Forum: Forms » HOW TO CAPTURE FRM-40350

Home » Developer & Programmer » Forms » HOW TO CAPTURE FRM-40350

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

HOW TO CAPTURE FRM-40350 [message #85915]

Wed, 11 August 2004 05:05

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.

Report message to a moderator

Re: HOW TO CAPTURE FRM-40350 [message #85917 is a reply to message #85915]

Wed, 11 August 2004 05:49

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;

Report message to a moderator

Re: HOW TO CAPTURE FRM-40350 [message #86043 is a reply to message #85917]

Tue, 24 August 2004 20:33

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

Report message to a moderator

Re: HOW TO CAPTURE FRM-40350 [message #233181 is a reply to message #85915]

Wed, 25 April 2007 02:27

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

Report message to a moderator

Previous Topic:	Form Generation at Unix Prompt
Next Topic:	Detail Record Disappear

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 29 15:50:10 CDT 2025