| Slow navigation [message #82113] |
Wed, 23 April 2003 11:06  |
Rishi
Messages: 63
Registered: January 2001
|
Member |
|
|
HI All!!!
i want that whenver user select any emp_code ..record of that emp_code displayed but when user press next button next record relating to that emp_code of branch should displayed...for this requirement i have write the follwing code
str:='where branch_code='||:br_code;
set_block_property('emp',default_where,str);
execute_query;
/* By this all employees record of perticular branch is fatched*/
/*now navigate one by one record so that record of perticular emp will reach*/
first_record;
loop
if :system.last_record='true' then
exit;
end if;
/* when record of desired employee code reach
loop will exit*/
if :emp.emp_code=req_emp_code then
exit;
end loop;
but navigation of one by one record is time consuming number if employee is more.
..if i set the default_where property so that only perticular employee's record will fatch but then no use of Previous /next buttons...
plz suggest me solution
Rishi
|
|
|
|
| Re: Slow navigation [message #82117 is a reply to message #82113] |
Thu, 24 April 2003 05:42  |
magnetic
Messages: 324
Registered: January 2003
|
Senior Member |
|
|
the idea of pressing next seems bullshit to me.
just make a block with +- 20 records
and set the default where to the emp_code.
you might give more select directives then just the emp_code, so your select result will be smaller
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
