OraFAQ Forum: Forms » I get FRM 40350 error,but records are getting displyed

Home » Developer & Programmer » Forms » I get FRM 40350 error,but records are getting displyed (forms 6i oracle 9i)

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

I get FRM 40350 error,but records are getting displyed [message #337867]

Fri, 01 August 2008 07:09

adchax
Messages: 32
Registered: June 2008

Member

I get the FRM 40350 error,when i query a certain query only and the correct record is displayed but it still displays this error that no record found.
I tried supressing the message but then it supressed all the useful one also with
supress.message_level:=25
Could you tell me what the reason is,or how to supress that message particularly.

Report message to a moderator

Re: I get FRM 40350 error,but records are getting displyed [message #337868 is a reply to message #337867]

Fri, 01 August 2008 07:16

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is there, perhaps, another block (which is "empty" after executing a query and responsible for this message)?

If you want to suppress this message, create a form-level ON-ERROR trigger which would look like this:

if err_type = 'FRM' and err_code = '40350' then
   null;
end if;

Report message to a moderator

Re: I get FRM 40350 error,but records are getting displyed [message #337871 is a reply to message #337868]

Fri, 01 August 2008 07:40

adchax
Messages: 32
Registered: June 2008

Member

there is case like that where one of the blocks are empty,but it doesnt show for that record,and that code didnt work from PRE-FORM trigger
where else can i try it ?

Report message to a moderator

Re: I get FRM 40350 error,but records are getting displyed [message #337876 is a reply to message #337871]

Fri, 01 August 2008 07:50

adchax
Messages: 32
Registered: June 2008

Member

as a matter of fact I have 3 blocks on my form,if one is filled and the rest are empty then 'There are no records' pops up as a message
Otherwise if 2 or more blocks are filled then it only shows in the below bar.

Report message to a moderator

Re: I get FRM 40350 error,but records are getting displyed [message #339587 is a reply to message #337876]

Thu, 07 August 2008 21:19

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

So, does this mean that you have solved your problem or not solved your problem?

David

Report message to a moderator

Re: I get FRM 40350 error,but records are getting displyed [message #339664 is a reply to message #339587]

Fri, 08 August 2008 01:53

adchax
Messages: 32
Registered: June 2008

Member

I was bale to solve my problem,there was a execute_query that i could make do without,which i iremoved and that seemed to solve the problem.

Thank You for all the help.

Report message to a moderator

Previous Topic:	A checkbox issue
Next Topic:	Delete a DETAIL record,causes HEADER column values NULL/ZERO for old Record (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 12 12:10:19 CDT 2025