| forms/search error urgent [message #82392] |
Fri, 23 May 2003 08:58 |
jels
Messages: 29
Registered: April 2003
|
Junior Member |
|
|
in new form search (i will call this form as popup window in main form)
in pre-form in form level i wrote
declare
rg varchar(40) := 'SEARCH_LIST'; //where search_ list is is lisit item
groupid recordgroup;
status number;
begin
groupid := create_group_from_query(rg,'select product_no,product_no from product_master');
status := populate_group(groupid);
populate_list('SEARCH_LIST',groupid);
end;
2 block_level
in when_validate_item in block level in search-pattern(text item)
i wrote
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;
the code is compiled and with no error and tried to run the form then it gives these errors
frm-30190 no list items defined for tlist
frm-30085 unable to adjust form for output
how to add items i already added the code to popluate the items when i pressing shift + f1 nothing is happenig pls hlp thanks in advance
by
jels
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
