oracle post

Hello everyone:  

I use ORACLE 7.1, SQL*Forms 3.0, SUN OS 5.4, SPARC Workstation. Please help me out the following problem:  

Because the long text field don't allow to enter query condition, I enter the query condition in the dummy character field v_qword1, then use  

        select question_wording into :question_wording
        from archive.question_wording
        where upper(question_wording) like '%' || upper(:v_qword1) || '%';
 

Note: question_wording is the long text field in the table archive.question_wording.  

But the result of query returns more than one rows. So I defined a cursor to hold the multiple rows, the program looks like:  

      DECLARE
      CURSOR QWORD IS
      SELECT QUESTION_WORDING FROM
      ARCHIVE.QUESTION_WORDING
      WHERE upper(QUESTION_WORDING) LIKE '%' || upper(:V_QWORD1) || '%';
      BEGIN
        OPEN QWORD;
        LOOP
        FETCH QWORD INTO :QUESTION_WORDING;
        EXIT WHEN
        QWORD%NOTFOUND;
      END LOOP;
      CLOSE QWord;
      END;
 

Then when I runforms, it just displayed the last row of the query result. So I'd like to know how to hold the multiple rows of the query result and when press DOWN key it will display the next row, which trigger I should use. I tried pre-query and post-query defined by the above program and no rows returned. Now I use post-field and I don't think this is a good one. Any good idea? Thanx for your patient to read my email. Your help will be really appreciated.  

julia    

   Zhe Yu Tel: (860)486-3001 Fax: (860)486-6308  

   zhe_at_opinion.isi.uconn.edu zhy95002_at_uconnvm.uconn.edu  

   University of Connecticut