Solved

ITS URGENT next match word

Posted on 2014-01-19
6
268 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 35

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL Convert to PL/SQL 23 81
Performance issue with case statement in oracle 11G 7 48
Shredding xml into an oracle 11g Database 2 31
constraint check 2 20
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

863 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

28 Experts available now in Live!

Get 1:1 Help Now