Home » Developer & Programmer » Forms » value default for list item of record group
value default for list item of record group [message #634868] Tue, 17 March 2015 03:45 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
hi all,
i have a block(block_inf) for display or update information of person specific.
for example EMP table that have a filed named Department_id.
i want show Department_name Instead of Department_id and User can edit the department.
i changed type of Department_id Item to ListItem and Poplist.
i create a RecordGroup below and named RG_Depts:
select dept_name,to_char(dept_id)dept_id from department;

and set element list....
also i used this code in When_new_instance_block trigger of block_inf:
declare lv_dep number;
        lv_where varchar2(1000);
begin
  lv_dep:=populate_group('RG_Depts');
  populate_list('department_id','RG_Depts');
  /*and other codes for execute_query :*/
  /*block search is in other canvas and other window*/
  lv_where:=' emp_id='||:block_search.emp_srch;
  /*block_inf is databased block*/
  set_block_property('block_inf',Default_where,lv_where);
  execute_query;
end;

Now,when showed information of person specific(showed block_inf) Department_name(or department_id) not equals department_name of person specific and it is no value.
but when open list it have list of department name...
why?

[Updated on: Tue, 17 March 2015 03:47]

Report message to a moderator

Re: value default for list item of record group [message #634876 is a reply to message #634868] Tue, 17 March 2015 06:02 Go to previous message
hahaie
Messages: 194
Registered: May 2014
Senior Member
clear all value for Elementlist property,it is solved!!!!
Previous Topic: log in script
Next Topic: DEBUG.SUSPEND
Goto Forum:
  


Current Time: Fri Aug 14 21:54:48 CDT 2020