Home » Developer & Programmer » Forms » display field visual attribute (forms6i)
display field visual attribute [message #686487] Sun, 25 September 2022 15:06
rhnshk
Messages: 26
Registered: May 2008
Junior Member
hi
i am changing the VA of a tabular recoeds through post-query.
i have a display non-db field, to which the VA is not getting applied.
my code in post-query is somethig like the below;

if  :mprh_status = 'O' then --Open MPR
	 	:m_status := 'Open';
   	set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_O');
	  set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_OPEN');
   	set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_OPEN');
   	set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_OPEN');
   	set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_OPEN');
elsif  :mprh_status = 'C' then --Closed/Cancel MPR
		:m_status := 'Close';
   	set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_C');
   	set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_CLOSE');
   	set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_CLOSE');
   	set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_CLOSE');
   	set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_CLOSE');
elsif  :mprh_status = 'A' then --Approved MPR
		:m_status := 'Approved';
   	set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_A');
   	set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_APPROVED');
   	set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_APPROVED');
	  set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_APPROVED');
   	set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_APPROVED');
end if;
what surprises me is just m_acnt_name VA does not gets change at runtime, which is a non-db field.

thanks
Previous Topic: fetch resutl of a query in a variable
Next Topic: CLIENT_TEXT_IO.fopen wont work if Application is started using a
Goto Forum:
  


Current Time: Thu Mar 28 09:25:36 CDT 2024