Home » Developer & Programmer » Forms » Define Global Variable (Form 6i)
Define Global Variable [message #471098] Thu, 12 August 2010 06:23 Go to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

Hi ,

I want to define global varible in oracle form 6i....so this varible may i used anywhere in project...but i dont know where
exactly global variable defined???

Please somebody help me...
Re: Define Global Variable [message #471103 is a reply to message #471098] Thu, 12 August 2010 06:37 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you tried looking it up in form builder help?
It does tell you this.
Re: Define Global Variable [message #471107 is a reply to message #471103] Thu, 12 August 2010 06:48 Go to previous messageGo to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

Can u tell me please...where to find ???
Re: Define Global Variable [message #471108 is a reply to message #471107] Thu, 12 August 2010 06:52 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
/forum/fa/8167/0/
Re: Define Global Variable [message #471109 is a reply to message #471108] Thu, 12 August 2010 06:57 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Or you could just press F1
Re: Define Global Variable [message #471552 is a reply to message #471109] Mon, 16 August 2010 02:40 Go to previous messageGo to next message
wjw31607618
Messages: 2
Registered: March 2010
Location: China
Junior Member
as I recall, it can only define global varible in 'on-logon' and 'pre-form'.
Re: Define Global Variable [message #471561 is a reply to message #471552] Mon, 16 August 2010 03:18 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
You recall wrong.
Re: Define Global Variable [message #471584 is a reply to message #471561] Mon, 16 August 2010 04:13 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,

As said cookiemonster / Littlefoot you can search it in form builder help.

As a Sample I want to give an Idea abt Globla variable.


KEY-NEXT-ITEM

Declare
  P varchar2(25);
Begin
  Select  UserPassword into :Global.P   from Duser
  where  username='NZ';
  If  (:password=:Global.P ) then
       :Global.A:=2;
		    
     Call_form( 'E:\STORE\DEMAND_TYPE.fmx',Hide);
     Clear_form;
     :Global.A:=2;
	   
    Else
    Message('Please Enter the Correct Password');
    Message('Please Enter the Correct Password');
    Clear_form;
		
   End if;
End;



Hope this'll help you.

Regards,

Irfan
Previous Topic: Old Value on Update
Next Topic: Validation problem when updating
Goto Forum:
  


Current Time: Fri Sep 20 06:54:10 CDT 2024