Oracle Forms 6i List of Values

Hello Experts,

Can you please advise me on this:

I have a form [6i]with 'Tabs'.
I have a LOV in tab 'region'.user invokes the LOV and selects a value from it and saves the record.It works fine. If the user does not select the value from LOV by clicking 'Cancel'
then I retrieve the existing value by using get_item_property.when i click on second tab 'sales' and come back to tab 'region' forms prompts 'Do you want to save changes you have made'.I have  not made any change.How can I suppress 'Do you want to save changes'??
if :region.reason = 1 then


      DECLARE
             dummy       BOOLEAN;
      BEGIN

          dummy := Show_LOV('constraints',460,130);
          IF NOT DUMMY then
          :region.onreason := get_item_property('region.onreason',database_value);
          
                      raise form_trigger_failure;
          end if;
             END;


 end if;

Thanks
if :region.reason = 1 then
 
 
	DECLARE
		 dummy	 BOOLEAN;
	BEGIN
 
    	dummy := Show_LOV('constraints',460,130);
    	IF NOT DUMMY then
    	:region.onreason := get_item_property('region.onreason',database_value);
    	
    			raise form_trigger_failure;
    	end if;
		 END; 
 
 
 end if;

Open in new window

spsunAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ritesh_GargCommented:
Try this:
DECLARE
   dummy          BOOLEAN;
   l_rec_status   varchar2(10);
BEGIN
   l_rec_status := get_record_property(to_number(:system.cursor_record),:system.current_block, status);
   dummy := Show_LOV('constraints',460,130);
   IF NOT DUMMY then
     :region.onreason := get_item_property('region.onreason',database_value);
     raise form_trigger_failure;
   end if;
  set_record_property(:system.cursor_record),:system.current_block, status, l_rec_status);
END; 

Open in new window

Ritesh_GargCommented:
A correction:
DECLARE
   dummy          BOOLEAN;
   l_rec_status   varchar2(10);
BEGIN
   l_rec_status := get_record_property(to_number(:system.cursor_record),:system.current_block, status);
   dummy := Show_LOV('constraints',460,130);
   IF NOT DUMMY then
     :region.onreason := get_item_property('region.onreason',database_value);
     set_record_property(:system.cursor_record),:system.current_block, status, l_rec_status);
     raise form_trigger_failure;
   end if;
END; 

Open in new window

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.