Solved

ITS URGENT next match word

Posted on 2014-01-19
6
266 Views
Last Modified: 2014-06-11
I have a fewrecords in a block which contains
4 fields in it.I want to search/find on a particular word on a field and go to the particular record in that group displayed and then to the next matching word until the end of the records like in excel.

if anybody knows pls help


Thanks in Advance
Hina mansoor
0
Comment
Question by:hinamansoor
6 Comments
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39793508
your requirement is as good as getting the input parameter i,e the value which you wanted to search/find and then use it in the where clause of the datbase block so that it can populate the multi record database block with only those records which match the input criteria.

You can use the built ins to set the where clause accordingly in the pre-query or etc triggers to get this done right. Sorry it is many years i had used oracle forms so do not remember the exact trigger names now.

Thanks,
0
 

Author Comment

by:hinamansoor
ID: 39793628
Sir i am using this on WHEN-VALIDATE-ITEM but i am not getting result as i expected This code will when i will pressed Enter Button

Example : TYPE "SM"---Pressed Enter: Result "SMITH" I don't want to press any button it shoud come while typing as i said like in excel.


:GLOBAL.g_text := '%'||:EMP.ENAME||'%';
DECLARE
        cursor c1 IS
                    SELECT empno, ename
                    FROM emp e
 WHERE e.ename LIKE :GLOBAL.g_text;
BEGIN
 OPEN c1;
 FIRST_RECORD;
 LOOP
    FETCH c1 INTO :EMP.empno, :EMP.ENAME;
  EXIT WHEN c1%NOTFOUND;
 -- NEXT_RECORD;
 END LOOP;
 CLOSE c1;
END;
--FIRST_RECORD;
Erase('GLOBAL.g_text');


I know this code is correct but trigger is issue i tried to use this code by creating timer but result is not as i expected can any body tell me which trigger hits after every single word typing.



Thanks
Hina mansoor
0
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 39794948
No, Oracle Forms does not have a trigger like this: "which trigger hits after every single word [of] typing".

The "when-validate_item" trigger fires only after the operator attempts to leave the item.  This can happen by pressing the Tab key, the down arrow, the up arrow, etc, or by clicking: (or choosing from the menu:) "Next record", "Next block", "Previous record", "Previous block", "Save", etc.

But no, there is no Oracle Forms trigger that fires after each letter or word is typed into a text field.
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39795994
i guess markgeet is right here but just open up the forms documentation manual and look /search for when key pressed or sort of such key words to see if any trigger exists which can help for your requirement.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 40126648
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now