Home » Developer & Programmer » Forms » How to trap FRM-40350 in Forms
How to trap FRM-40350 in Forms [message #80596] Fri, 18 October 2002 08:40 Go to next message
Swamy
Messages: 78
Registered: June 2002
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 write some other code, like hide the canvas, when EXECUTE_QUERY returns no data. Please guide me how can I accomplish this task. I appreciate in advance for your help.

Report message to a moderator

Re: How to trap FRM-40350 in Forms [message #80599 is a reply to message #80596] Fri, 18 October 2002 13:32 Go to previous messageGo to next message
ram kumar
Messages: 113
Registered: August 2002
Senior Member
hi,
try using on-error,on-message triggers...

regards
ram

Report message to a moderator

Re: How to trap FRM-40350 in Forms [message #80640 is a reply to message #80596] Thu, 24 October 2002 15:05 Go to previous message
Zaire
Messages: 36
Registered: October 2002
Member
Try this:

if get_block_property('blockname',query_hits) = 0
then
do_your_stuff;
end if;

Report message to a moderator

Previous Topic: what should be source.
Next Topic: forms6i-urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 15:47:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.