Home » Developer & Programmer » Forms » 10G-form: How to do MULTIPLE WORD OR SINGLE WORD SEARCH at ITEM?
10G-form: How to do MULTIPLE WORD OR SINGLE WORD SEARCH at ITEM? [message #216261] Thu, 25 January 2007 17:23 Go to next message
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
Re: 10G-form: How to do MULTIPLE WORD OR SINGLE WORD SEARCH at ITEM? [message #216332 is a reply to message #216261] Fri, 26 January 2007 09:48 Go to previous messageGo to next message
gogo25
Messages: 5
Registered: January 2007
Junior Member
Pl help me out.
Thanks.
Re: 10G-form: How to do MULTIPLE WORD OR SINGLE WORD SEARCH at ITEM? [message #216493 is a reply to message #216332] Sun, 28 January 2007 22:42 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why don't you have the text string in a LIKE component in the 'Default_where'?

David
Previous Topic: Please advice me how to debug...
Next Topic: How To Convert Arabic Name To English
Goto Forum:
  


Current Time: Wed Dec 07 14:58:44 CST 2016

Total time taken to generate the page: 0.07701 seconds