OraFAQ Forum: Forms » How to call Matching Record

Home » Developer & Programmer » Forms » How to call Matching Record (9i, 9.0.1.1, XP)

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

How to call Matching Record [message #661227]

Sat, 11 March 2017 07:16

billgates
Messages: 19
Registered: March 2017

Junior Member

Hey fellas I have database 9i 9.0.1.1 with Forms 6i.

I have a form with two text items ITEM_A, ITEM_B.
ITEM_B calls Description from the following table.

SQL> SELECT * FROM IMS_ITEMCATEGORY;

CATCODE DESCRIPTION
---------- ---------------------
01 ENGINE
02 TRANMISSION
03 SUSPENSION
04 ELECTRICAL
05 INTERIOR
06 EXTERIOR
07 BRAKING
08 ACCESSORIES
09 SEALS
10 FILTERS
11 BELTS
12 FASTNERS
12 OIL & LUBRICANT
13 rows selected

Now what I want is as I type a phrase in ITEM_A which contains a word from the description in the given table and press enter, The ITEM_B should be filled with the related description.
For Example

I type ""V BELT 2240"" in ITEM_A and press enter. The ITEM_B should be filled with the related category like ""BELTS"".
Now ITEM_A will have matching word like BELT but how many characters or words will come before or after it is a myth.

Do anyone have an idea how to do it?

[Updated on: Sat, 11 March 2017 07:17]

Report message to a moderator

Re: How to call Matching Record [message #661229 is a reply to message #661227]

Sat, 11 March 2017 08:12

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

What is the relation between your ITEM_A, ITEM_B and the query you posted which has none of them?

Quote:

I type ""V BELT 2240"" in ITEM_A and press enter. The ITEM_B should be filled with the related category like ""BELTS"".
Now ITEM_A will have matching word like BELT but how many characters or words will come before or after it is a myth.

ITEM_A like '%'||rtrim(ITEM_B,'S')||'%'

Report message to a moderator

Re: How to call Matching Record [message #661230 is a reply to message #661229]

Sat, 11 March 2017 10:20

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You have two categories number 12. That's probably wrong.

What if there's a new category (14) whose description is 'BRAKING OIL', and user enters "OIL" into ITEM_A. Which "OIL" category will you display?
- 12 OIL & LUBRICANT, or
- 14 BRAKING OIL?

That's just an example (probably not a very smart one), but I hope you understand my point - there might be similar categories, and you have to pick only one; otherwise, your query will return the TOO-MANY-ROWS error.

Report message to a moderator