Re: Forms 4.5

Forms default behavior will allow the following:

F7 (enter query mode)
Enter "0%" (without the quotes in the part number field F8 (execute query)
All part numbers starting with 0 will be returned from the database. You either need to set up your block as a multi-record block or you will have all of the resulting part numbers in a single record block accessible through next_record (DownArrow, PageDown) and previous_record (UpArrow,PageUp).

Hope this helps,

Randy Meisner
Senior Consultant
ROMAC Emerging Technologies

In article <81fo6g$kae$1_at_bgtnsc02.worldnet.att.net>,   "David DeLisser" <d.delisser_at_worldnet.att.net> wrote:
> Please help! I know this has to be easy, but I'm new to Oracle Forms
4.5.
> Question - I have a block with one field on it called PN for Part
Number. I
> want to be able to put any PN in and automatically get all records
(field's)
> that are like that PN. For example, I want PN%. If I put in a "0", I
want it
> to display all PN's starting with 0 and so on. I tried a pre-query
on the
> block but could not get it to work.
> Please help me!!!!
> Jeannie
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 17:50:01 CST