OraFAQ Forum: Forms » Frm-92101

Home » Developer & Programmer » Forms » Frm-92101 (10g)

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

Frm-92101 [message #567826]

Sat, 06 October 2012 03:55

shanie
Messages: 118
Registered: January 2011

Senior Member

Hi,

Please see the attached file.
I get the error when I go to second block after filling the first block.
After adding the code in where clause property pallete on database block.
i.e. gzgcdsc_id = :dual.gzgcdsc_id.
I get this kind of error.

Please help.

Thanks & Regards,
Shanie

Attachment: screen.JPG
(Size: 78.91KB, Downloaded 1028 times)

Report message to a moderator

Re: Frm-92101 [message #567834 is a reply to message #567826]

Sat, 06 October 2012 13:49

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

Senior Member
Account Moderator

No idea, but - try to rename the DUAL block to something that doesn't sound that Oracleish.

Report message to a moderator

Re: Frm-92101 [message #567859 is a reply to message #567826]

Sun, 07 October 2012 06:59

shanie
Messages: 118
Registered: January 2011

Senior Member

when I remove code from Where clause property pallete. The form is working fine.
But All records from database are coming in second block. I want to retrieve the records based on student ID that is not happening.
I have written code in when new block instance trigger

BEGIN
 	 SELECT count(*) into temp 
 	  FROM 			SATURN.GZGCDSC 
 	  WHERE 		GZGCDSC_ID = :dual.GZGCDSC_ID;
	  
	  IF SQL%FOUND THEN
	  	go_block('DUMMY');
  	SET_BLOCK_PROPERTY('DUMMY', DEFAULT_WHERE, 'GZGCDSC_ID = ''' || :DUAL.GZGCDSC_ID);
 		EXECUTE_QUERY;
		GO_ITEM('DUMMY.GZGVDSC_DSC_TYPE');
	  END IF;
	  
	  EXCEPTION 
	  	WHEN no_data_found THEN
	  		go_block('DUMMY');
	  		:DUMMY.GZGCDSC_ID := :DUAL.GZGCDSC_ID;
	  		:DUMMY.GZGCDSC_PIDM := :DUAL.GZGCDSC_PIDM;
	  		:DUMMY.GZGCDSC_TERM := :DUAL.GZCDESC_TERM;
	  		go_item('DUMMY.GZGVDSC_DSC_TYPE');
	
	WHEN others THEN
		MESSAGE(SQLERRM, SQLCODE);
	  END;

Please reply

Regards,
Shanie

Report message to a moderator

Re: Frm-92101 [message #567864 is a reply to message #567859]

Sun, 07 October 2012 14:12

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

Senior Member
Account Moderator

I see that you still didn't rename DUAL block to something else (I'm not saying that this WILL do any good, but I don't have any better idea). Also, try to recompile the form (Ctrl + Shift + K).

Remove the whole EXCEPTION section; NO_DATA_FOUND will never be raised with that code, and WHEN OTHERS is simply useless.

Report message to a moderator

Re: Frm-92101 [message #568243 is a reply to message #567864]

Wed, 10 October 2012 06:03

simonkimbrell
Messages: 4
Registered: September 2008

Junior Member

Have you tried creating a relation ship between the blocks?

Report message to a moderator

Re: Frm-92101 [message #568247 is a reply to message #568243]

Wed, 10 October 2012 06:12

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

This if is pointless:

IF SQL%FOUND THEN

It'll always be true with that select.

This looks wrong:

SET_BLOCK_PROPERTY('DUMMY', DEFAULT_WHERE, 'GZGCDSC_ID = ''' || :DUAL.GZGCDSC_ID);

Why do you have the three quotes together?

Report message to a moderator

Re: Frm-92101 [message #568873 is a reply to message #568247]

Wed, 17 October 2012 06:07

shanie
Messages: 118
Registered: January 2011

Senior Member

Dear All,,

Sorry I made a mistake in Set_block_property code.
I have rectified this error.
The form is working now.
I observed one Bug in my form is that when I delete the last record through form and then click on save It is giving customized error which I put in Pre-commit Trigger.

begin
if :dummy.GZGCDSC_DSCS is null or :dummy.GZVDTYP_DSC_CODE is null or :dummy.GZGCDSC_MEETING_NO is null or :dummy.GZGCDSC_TERM is null then
MESSAGE('Fields cannot be left blank',ACKNOWLEDGE);
RAISE FORM_TRIGGER_FAILURE;
end if;
end;

If I remove this code and place this in Post Query or When new record Instance Triggers
It is saving the record with only one field filled and others empty.
My criteria is I do not want the User to save Record with any of the above fields are empty.
How should I do this?
Please Advise.

Thanks & Regards,
Shanie

Report message to a moderator

Re: Frm-92101 [message #568875 is a reply to message #568873]

Wed, 17 October 2012 06:15

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why not just set the fields to required?

Report message to a moderator

Re: Frm-92101 [message #568883 is a reply to message #568875]

Wed, 17 October 2012 07:03

shanie
Messages: 118
Registered: January 2011

Senior Member

It did not solve with required field set to YES.
There is LOV attached with two fields and if We enter in field without clicking on LOV Button first then It will not allow to exit the field without entering something in the field.

Regards,
Shanie

Report message to a moderator