Home > IT Answers > Oracle > Searching using Oracle Forms
Raza
15 pts.
 Searching using Oracle Forms
Oracle 10g, Oracle development, Oracle Forms
Hi to all.I am tauqeer.I am using oracle 10g forms developer I want to search some data in the tabular form style in the form based on a query on a text item.I want when i press enter button which is under that text item the data will be displayed in the tabular saction.the text item and enter button are on the same form but not in tabular saction of the form. Please qnswer me quickly and be specific. Thanx in advance.

Software/Hardware used:
ASKED: October 8, 2008  4:01 AM
UPDATED: February 20, 2009  8:42 AM
RELATED QUESTIONS
Answer Wiki:
Hi If you got a solution to your problem. kindly let me know as well i am also facing the same kind of problem. hoping for a helpful reply
Last Wiki Answer Submitted:  December 23, 2008  9:25 am  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

suppose
if you have to get the details from the emp table based on the empno when ever you click on the
‘Enter Button’ then write the following code in ‘When-Button-Pressed’ trigger.

declare
cursor c1 is select ename,sal,job from emp where empno=:emp.empno;
begin

open c1;
loop
fetch c1 into :ename,:sal,:job;
exit when c1%notfound;
end loop;
close c1;
end;

try like this once.

D2k
 40 pts.