السلام عليكم

انا لدى فورم من نوع TABULAR

وكنت عايز كل ريكورد يبقى ليه lov خاص بيه بيتم بناء record_group من جملة sql مخزنة فى الداتابيز ووضعها فيها واستخدامها فى lov الخاصة بالريكورد

وشكرا

I will list steps to perform this issue because I haven't time to create sample

create your default LOV and Record Group in design time and assign it to Text Item in block

create When-New-Record-Instance trigger on block

then write this code in previous trigger

note replace sql_stmt and LOV_NAME by names you used

[/left]



[left]DECLARE
   rg_name VARCHAR2(40) := 'Temp_Group';
   rg_id RecordGroup;
   errcode NUMBER;
   sql_stmt varchar2(512);
BEGIN
   sql_stmt := 'select 1 from dual';--assign it to your sql statement which stored in database
   rg_id := Find_Group( rg_name );
    IF not Id_Null(rg_id) THEN
        Delete_Group( rg_id );
    END IF;
    rg_id := Create_Group_From_Query( rg_name,sql_stmt);
    errcode := Populate_Group( rg_id );
    set_lov_property('LOV_NAME',group_name,rg_name);
END;[/left]

I will list steps to perform this issue because I haven't time to create sample

create your default LOV and Record Group in design time and assign it to Text Item in block

create When-New-Record-Instance trigger on block

then write this code in previous trigger

note replace sql_stmt and LOV_NAME by names you used

[/left]



[left]DECLARE
rg_name VARCHAR2(40) := 'Temp_Group';
rg_id RecordGroup;
errcode NUMBER;
sql_stmt varchar2(512);
BEGIN
sql_stmt := 'select 1 from dual';--assign it to your sql statement which stored in database
rg_id := Find_Group( rg_name );
 IF not Id_Null(rg_id) THEN
	 Delete_Group( rg_id );
 END IF;
 rg_id := Create_Group_From_Query( rg_name,sql_stmt);
 errcode := Populate_Group( rg_id );
 set_lov_property('LOV_NAME',group_name,rg_name);
END;[/left]

لم تعمل يا اخى
رسالة الخطأ:
FRM-41075 Error Deleting Group.
FRM- Agrument 2 to buildin Create_group_from_query. Cann't be null

Kindly send me your code which you used

Kindly send me your code which you used

Created Record_Group Name== Tmp_group
with query === select 'aa','0' from dual

DECLARE
    rg_name VARCHAR2(40) := 'Tmp_Group';
    rg_id RecordGroup;
    errcode NUMBER;
    sql_stmt varchar2(512);
BEGIN
--assign it to your sql statement which stored in database
    sql_stmt := :select_stm;
    rg_id := Find_Group( rg_name );
	 IF not Id_Null(rg_id) THEN
			 Delete_Group( rg_id );
	 END IF;
	 rg_id := Create_Group_From_Query( rg_name,sql_stmt);
	 errcode := Populate_Group( rg_id );
	 set_lov_property('LOV_test',group_name,rg_name);
END;

تم تعديل 15 مارس 201214 سنة بواسطة Mido_17