OraFAQ Forum: Forms » GET_FORM

Home » Developer & Programmer » Forms » GET_FORM_PROPERTY

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

GET_FORM_PROPERTY [message #381137]

Thu, 15 January 2009 06:50

mylraj
Messages: 16
Registered: January 2009
Location: Manama

Junior Member

Hi,

can anyone please solve this

i am getting an error

frm 40738 argument 2 builtin get_form_property can not be null

FORM_NAME:=:SYSTEM.CURRENT_FORM;
--MESSAGE(FORM_NAME);
FIRST_BLOCK:=GET_FORM_PROPERTY(FORM_NAME,FIRST_BLOCK);
LAST_BLOCK:=GET_FORM_PROPERTY(FORM_NAME,LAST_BLOCK);

Regards

Report message to a moderator

Re: GET_FORM_PROPERTY [message #381141 is a reply to message #381137]

Thu, 15 January 2009 07:23

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Oracle Forum Says...

Quote:

This usually occurs when an exception occurs in a plsql block in the form, like under when new form instance or when button pressed. The form can still be closed by clicking on the 'x' of the form itself, not the warning window.

Follow the instructions of the headstart manual on how to implement the when-button-pressed code (look at the example). You may want to play with the unhandled_exception line, since in some of my cases this line causes the unwanted behaviour.

http://forums.oracle.com/forums/thread.jspa?messageID=596514

Javed

[Updated on: Thu, 15 January 2009 07:24]

Report message to a moderator

Re: GET_FORM_PROPERTY [message #381142 is a reply to message #381137]

Thu, 15 January 2009 07:29

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

Senior Member
Account Moderator

I wouldn't name my variables as you did; why wouldn't you rather do something like

  my_first_block varchar2(30);
begin
  my_first_block := get_form_property(:system.current_form, first_block);
end;

Generally speaking, it is a bad idea naming any of your objects (columns, variables, tables, ...) by using a name of (potentially) Oracle reserved word or keyword. If it smells like it, don't use it; there are many other possibilities (such as MY_, L_ (as "Local_") etc.).

Report message to a moderator

Re: GET_FORM_PROPERTY [message #381559 is a reply to message #381142]

Sun, 18 January 2009 05:58

mylraj
Messages: 16
Registered: January 2009
Location: Manama

Junior Member

Thanks for your reply,it works fine now

Report message to a moderator

Previous Topic:	Help ASAP-Can't login as Hrms/hrms@lid as sysdba at forms/Reports developer
Next Topic:	determining cd rom's drive letter in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 08:12:31 CST 2025