can someone please work me through the process of creating a combox box.
I would like to give the user to use the combox as both a search capability.
I have created the following code but it is not working.
I am getting an error that "no list elements defined for list item.
What I did was create a button and in the property's window, changed the name 'SEARCH'.
If you can, please tell me how to get started and what trigger.
When to when-validate-item trigger (item level) and wrote following code:
declare
rg_id recordgroup;
x number;
begin
rg_id := create_group_from_query('Call_Dates','select calls._Cals_time,
calls._Cal_Id,
calls._Ref_Id,
calls._Res_Id
from calls
where calls._Cals_time = :_Cals_time
OR calls._Cals_Id = :calls.Cals
OR calls._Ref_Id = :calls.Ref
OR calls._Res_Id = :calls.Rest
order by 1');
x := populate_group('Call_Dates');
populate_list('calls._cals_time','Call_Dates');
end;
thanks in advance
I would like to give the user to use the combox as both a search capability.
I have created the following code but it is not working.
I am getting an error that "no list elements defined for list item.
What I did was create a button and in the property's window, changed the name 'SEARCH'.
If you can, please tell me how to get started and what trigger.
When to when-validate-item trigger (item level) and wrote following code:
declare
rg_id recordgroup;
x number;
begin
rg_id := create_group_from_query('Call_Dates','select calls._Cals_time,
calls._Cal_Id,
calls._Ref_Id,
calls._Res_Id
from calls
where calls._Cals_time = :_Cals_time
OR calls._Cals_Id = :calls.Cals
OR calls._Ref_Id = :calls.Ref
OR calls._Res_Id = :calls.Rest
order by 1');
x := populate_group('Call_Dates');
populate_list('calls._cals_time','Call_Dates');
end;
thanks in advance