Re: ComboBox(B

Hallo,

here is an example when-new-form-trigger. If executed somewhere else in the form you carefully have to check initial and current value fits into the data.

hth
Stephan

DECLARE
  rg_svst VARCHAR2(40) := 'any_name';   rg_svst_id RecordGroup;
BEGIN
   :system.message_level := 10;

• fill RG for col_name rg_svst_id := Find_Group( rg_svst ); if not(id_null(rg_svst_id)) then delete_group(rg_svst_id); end if; rg_svst_id := Create_Group_From_Query( rg_svst, 'select to_char(col_name,''FM000'') || '' - '' || name1, to_char(col_name) from tab_name order by col_name'); ndummy := Populate_Group( rg_svst_id ); Clear_List('FORM_BLOCK.col_name'); Populate_List('FORM_BLOCK.col_name', rg_svst); ...

Stjepan Brbot schrieb:

> I use Developer 6i - Forms Builder for creating Oracle forms. How to
> populate an combobox with data returned as result of SQL query?
>
> --
>
> Stjepan Brbot [Stjepan.Brbot_at_ZG.HiNet.HR]

--
Mit freundlichen Gr$B|_(Ben

Stephan Langer,
QITS GmbH