Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Heelp need to walk through record

Re: Heelp need to walk through record

From: Karsten Farrell <kfarrell_at_medimpact.com>
Date: Mon, 28 Oct 2002 21:50:14 GMT
Message-ID: <qiiv9.1777$v73.111857704@newssvr13.news.prodigy.com>


P B wrote:
> I have a form which access a view. Record are access through a
> composite primary key (file no and item name). I am able to move from
> item to item using build-in like Next_Record, Previous_Record and
> Go_Record which keep me into insert mode.
>
> The problem: the item are name. I would like to move from one record
> to another without doing 200 times next record until I get the one
> that I want. Go_Record is not usefull because I do not know the number
> of the record associated to his name.
>
> I cannot also make a form (tab form) in which I list the record all in
> one page since there is too many information to show.
>
> Since I might modify some item, I do not want to exit the inserting
> mode and go into query mode to perform the search.
>
> How can I solve my problem

If I understand your question, I think you need a "search" capability. Put a textbox on your form where the user can enter an item name. When they click the Search button, your trigger calls up the record(s) where item name is like whatever they type in the search textbox. Received on Mon Oct 28 2002 - 15:50:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US