This content has been marked as final. Show 4 replies
thanks for the response
please donate an example ,
i have a button which have a trigger when-button-pressed
the lov_unit is base on the record group ,
declare g_lov boolean; begin g_lov :=show_lov(lov_unit); end ;
i did not really understood the use in the syntax , is it instead of the existance RG ? and where shold i write it down ?
please help i'm new to forms
Thanks In Advanced
Edited by: Naamas on 05:54 10/12/2012
Open Forms Builer then press F1 to get the online help. Seach for CREATE_GROUP() to get the exemple
You can populate the RG at startup time if the content does not change, or you can populate it at any time.
... /* ** Populate group with a query */ errcode := Populate_Group_With_Query( rg_id, 'SELECT SAL-MOD(SAL,1000),COUNT(EMPNO) ' ||'FROM EMP ' ||'GROUP BY SAL-MOD(SAL,1000) ' ||'ORDER BY 1'); END;
Can you tell me what are the values stored in the *:parameter.unit* ?
and region in (:parameter.unit)
I think the main problem is that you use in, that means that you try to store more then one value in your parameter.unit (something like 1,2,3) which result on the frm 40502 unable to read list of values.
Especialy if you REGION field is a number and your parameter in a char (which can accept the value 1,2,3 that a number parmameter won't accept)
Edited by: JeanYves Bernier on 11 déc. 2012 00:57