Xref: alice comp.databases.oracle.misc:17239
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!feed2.news.erols.com!erols!not-for-mail
From: "Peter H. Larsen" <plarsen.nospam@dc.dynares.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Populating rows of records using Forms 5?
Date: Tue, 07 Jul 1998 14:59:10 -0400
Organization: Dynamic Resources Inc.
Lines: 68
Message-ID: <35A26FFE.7A281C47@dc.dynares.com>
References: <6ntd22$50d$1@nnrp1.dejanews.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: winter.news.erols.com 899838055 17251 207.96.14.31 (7 Jul 1998 19:00:55 GMT)
X-Complaints-To: abuse@erols.com
X-Mailer: Mozilla 4.05 [en] (Win95; I)

Hi,

Want to populate a block? How about EXECUTE_QUERY?
What you're trying to do is totally redundant and should be avoided. Why
reinvent the wheel?
Define your block using a basetable item, define your items from your
base table (select the columns), press GENERATE and VOILA it works! No
programming necessary.

- Peter H. Larsen
  Oracle Consultant

vthean@yahoo.com wrote:
> 
> Hi, I'm new to Oracle Developer 2000; I need your help
> on how to populate rows of records with multiple
> columns to a data block. I created a data block(Block8)
> with two fields, last_name and first_name. I was able to
> populate only one row of data on the first display item
> but not the rest. I did set the "Number of Records Displayed"
> in RECORD on the property page for Block8 to 3. How do I
> get all the names to populate in block8? Thanks in advance.
> 
> Newbie,
> 
> --Vandy
> 
> Below is my source:
> 
> ***************
> declare
>   lname     varchar2 (20);
>   fname     varchar2 (20);
> 
>   cursor emp_tab is
>     select last_name, first_name
>     from employee_master
>     where department = :block3.dept;
> 
>   employee_info emp_tab%ROWTYPE;
> 
> begin
>   open emp_tab;
>   fetch emp_tab into employee_info;
>   while emp_tab%found
>   loop
>     :block8.last_name := employee_info.last_name;
>     :block8.first_name := employee_info.first_name;
>     fetch emp_tab into employee_info;
>   end loop;
>   close emp_tab;
> end;
> *********************************
> 
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum

-- 

Peter H. Larsen, Oracle and Applications specialist
Dynamic Resources Inc, Alexandria
Phone: 703-914-9800  #103
Fax: 703-914-9804
Email: plarsen@dc.dynares.com
(please remove the nospam from the header when replying to this email)

The above views are my own and does not reflect the views of my
employer.