Link to home
Start Free TrialLog in
Avatar of farhan786
farhan786

asked on

Oracle 8i forms stack canvas searching error

How are you,
  Hope every one fine, and enjoy health. Today I brought another headache in oracle 8i, hope you solve it because of vast experience.
  My question is simple and straight forward.
Q: I create one block know as search_block_form and another stack known as search_record (based on view). I create three item fields in search_block_form which are given below:
1)      Description varchar2 (100) contains area codes like Islamabad.
2)      Name varchar2 (50) contains name like Farhan
3)      Phone number (8) contains phone numbers like 879456

And in search_record stack canvas, I create view which has following fields:
1)      Name
2)      Phone
3)      Description
4)      Area hint

This means there are two data blocks one has search_form_block and other has search_record. I double click on search_record(Property Pallete) and goes from where clause and write this sricpt.
phone=:search_form_block.phone OR Upper(sub_name) like Upper(:search_form_block.sub_name)||'%'
According to this script, if you write name (full or partial) they search record in stack canvas means in search_record form or block.

 BUT there is some problem, like if you write phone number in search_block_form they show all records present in view, not specific one. And my other question is, i want to add description must, so that I ensure that phone or name viewed according to description.
For this I give simple example: there are two cities like new York and Manchester.
In your database there will be name and phone numbers of employees who lived in Manchester and some lived in new york

Manchester      New york
Elwin , 57-7854-58      Elwin khan, 9876-874-85
Hares, 789-874-852      Haik, 9876-852-3214

According to this table, there will be some employees name same, if you write name of elwin is in search_block_form, they show both cities employees, but I want that I print only those employees who live in specific cities along with other information which I mention above.
 I am waiting for you reply, please give me reply as sooon as possible.
          Farahn Khan


ASKER CERTIFIED SOLUTION
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think that you can split points.