| called form error/book [message #82462] |
Wed, 28 May 2003 13:35  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
