Solved

ITS URGENT next match word

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Developer 6 60
Oracle - SQL Query with Function 3 51
create a nested synonym 4 28
any step by steps guide on how to install Oracle 12c on Windows 10 8 55
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

791 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