NetNews Usenet Archive 1992 #26/NN_1992_26.iso/spool/comp/database/oracle/2129

Internet Message Format | 1992-11-07 | 1.7 KB

Path: sparky!uunet!portal!lll-winken!cert!netnews.upenn.edu!dsinc!cs.widener.edu!iggy.GW.Vitalink.COM!pacbell.com!decwrl!sdd.hp.com!saimiri.primate.wisc.edu!zaphod.mps.ohio-state.edu!rpi!scott.skidmore.edu!psinntp!psinntp!ncrlnk!ncrsoph!sstasuke
From: [e-mail] (Steve Stasukewicz)
Newsgroups: comp.databases.oracle
Subject: Need help with Forms 2.3
Message-ID: <[e-mail]>
Date: 5 Nov 92 14:56:15 GMT
Reply-To: [e-mail] (Steve Stasukewicz)
Organization: NCR European Development Center
Lines: 32


I'm using Forms 2.3 with Oracle V6 and have the following problem:

I'm trying to create a multi-row block that contains 3 columns of data.
Each column on the form comes from a different table in the database.
I have the block defined to have 10 rows.  If the query retrieves more than
10 rows I would like to be able to scroll downwards when I reach the last
row on the screen.  My first problem is how to populate the block.
Currently I have something like this that doesn't work at all.

select table1.field1, table2.field2, table3.field3
into   block1.f1, block1.f2, block1.f3
from   table1, table2, table3
where  ( join condition to join 3 tables )

This will retrieve a single row and put it into the correct fields on the
form, but it will not populate rows 2 thru 9 in the block.   ( I know there
is more than 1 record that meets the criteria.)  What am I doing wrong?
If it's not already obvious, I'm new to Forms.  Please HELP!

Thanks in advance.

Steve


---------
[e-mail]
NCR Europe Group ISS/ECS
Espaces De Sophia
25 Route de Lucioles                   Tel. [phone]
06560 Valbonne FRANCE                  Fax. [phone]
--