OraFAQ Forum: Forms » 10G-form: How to do MULTIPLE WORD OR SINGLE WORD SEARCH at ITEM?

Home » Developer & Programmer » Forms » 10G-form: How to do MULTIPLE WORD OR SINGLE WORD SEARCH at ITEM?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

10G-form: How to do MULTIPLE WORD OR SINGLE WORD SEARCH at ITEM? [message #216261]

Thu, 25 January 2007 17:23

gogo25
Messages: 5
Registered: January 2007

Junior Member

am using 10G DB + 10G Form Builder.
I've 'database_item' where I am storing multiline text data.
I want to do MULTIPLE WORD OR SINGLE WORD SEARCH at this item through FORM.
I've tried by creating the following NON Database Items on the form:
- multiline_search_text_item, and
- multiline_result__text_item
And then writing execute_query in KEY-NEXT-ITEM trigger.
*
I've also tried using this in the POST-TEXT-ITEM at multiline_search_text_item:
select table.database_item into :multiline_result__text_item from table where multiline_search_text_item = :multiline_search_text_item;

Pl help me asap.
Gaurav

Report message to a moderator