Home » Developer & Programmer » Forms » called form error/book
called form error/book [message #82462] Wed, 28 May 2003 13:35 Go to next message
jels
Messages: 29
Registered: April 2003
Junior Member
hi ,
iam not able to select the called form .I am notable to do anything in that form even select or click.Previously it
was workin fine what may be the cos.i pressed shift + f1 but it showing
frm 42100 no errors encountered recently

this is the code in a text box the selected number should be displayed
when-validate-item search_pattern

declare
rg varchar(40) := 'SEARCH_LIST';
groupid recordgroup;
status number;
begin
groupid := find_group(rg);
if not id_null(groupid) then
if :search_pattern = ' ' or :search_pattern is null then
status := populate_group_with_query(rg,'select product_no,product_no from product_master');
else
status := populate_group_with_query(rg,'select product_no,product_no from
product_master where lower(product_no) like
lower('''|| :search_pattern || '%'')');

end if;
populate_list('SEARCH_LIST',groupid);
end if;
end;
can u give some titles of good book in pl/sql and forms 6i that will be available in india(blr).i am looking application wise(project wise) i have ivan bayross forms4.5 and planning to be strong in this application devlopment especially in oracle domain

pls hlp
jels
Re: called form error/book [message #82471 is a reply to message #82462] Thu, 29 May 2003 06:21 Go to previous messageGo to next message
Sun
Messages: 92
Registered: August 2002
Member
If u are calling the other form what function u have used whether call_form, open_form, new_form..

But ur example shows different...

If u want to populate two lovs, u can create two record groups and in key list val u can give

declare
l_var boolean;
l_var2 boolean;
begin

if condition then
l_var := show_lov('lov name');
else
l_var2 := show_lov('lov name');
end if;
end;

the problem will be solved...

As per my knowledge best book is ivan bayross.. and u can make use of forms help itself...
Re: called form error/book [message #82487 is a reply to message #82471] Thu, 29 May 2003 20:53 Go to previous message
jels
Messages: 29
Registered: April 2003
Junior Member
the code is correct it was working i am not using
the lov's i am using the call_form procedure
but suddenly i am not able to select the called form
not able to click or any thing
Previous Topic: pl/sql internal error/master detail
Next Topic: f90servlet problem?
Goto Forum:
  


Current Time: Fri Mar 29 01:48:12 CDT 2024