Home » Developer & Programmer » Forms » Frm-40815 Error Variable Global.nofday does not exist (oracle 10g)
Frm-40815 Error Variable Global.nofday does not exist [message #502365] Wed, 06 April 2011 02:00 Go to next message
shanie
Messages: 118
Registered: January 2011
Senior Member
Hi,
I am using Global Variables to store the data from the form variables and once again restore it in the form when User ID is entered.

For this I write the code in Pre-commit trigger
:global.gzaoffe_nofday := :gzaoffe.gzaoffe_nofday;
:global.gzaoffe_time_period := :gzaoffe.gzaoffe_time_period;
:global.gzaoffe_time_from := :gzaoffe.gzaoffe_time_from;
:global.gzaoffe_time_to := :gzaoffe.gzaoffe_time_to;
:global.gzaoffe_date_from := :gzaoffe.gzaoffe_date_from;
:global.gzaoffe_date_to := :gzaoffe.gzaoffe_date_to;
:global.gzaoffe_official_reason := :gzaoffe.gzaoffe_official_reason;

Then I write the code in KEY-NEXT-ITEM trigger of gzaoffe.user_id
:gzaoffe.gzaoffe_nofday := :global.gzaoffe_nofday;
:gzaoffe.gzaoffe_time_period := :global.gzaoffe_time_period;
:gzaoffe.gzaoffe_time_from := :global.gzaoffe_time_from;
:gzaoffe.gzaoffe_time_to := :global.gzaoffe_time_to;
:gzaoffe.gzaoffe_date_from := :global.gzaoffe_date_from;
:gzaoffe.gzaoffe_date_to := :global.gzaoffe_date_to;
:gzaoffe.gzaoffe_official_reason := :global.gzaoffe_official_reason;

Form is compiling successfully. But when I enter the User ID It is showing the error FRM-40815 Variable GLOBAL.GZAOFFE_NOFDAY does not exist. Like this it is showing for all global variables.

This is troubling me alot.
Am I correct in my approach? Please help.

Regards,
Shanie

Re: Frm-40815 Error Variable Global.nofday does not exist [message #502377 is a reply to message #502365] Wed, 06 April 2011 02:49 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Globals don't exist until the first time they are assigned a value. Your key-next-item trigger will be getting fired before the pre-commit.
Assign all the globals to null in the pre-form trigger.
Re: Frm-40815 Error Variable Global.nofday does not exist [message #502439 is a reply to message #502377] Wed, 06 April 2011 05:48 Go to previous message
shanie
Messages: 118
Registered: January 2011
Senior Member
Problem Solved.
Thanks Alot.

Regards,
Shanie
Previous Topic: Error signature: FORMS
Next Topic: Dynamic Report by using Oracle Forms 6i
Goto Forum:
  


Current Time: Wed Aug 04 00:40:58 CDT 2021